Integration Overview - NetSuite

Products & SKUs

NetSuite Items will be synced as either Products or SKUs depending on associated information.

Which Items will sync to JOOR?

You will work with your JOOR Integrations Manager to define the criteria for synchronizing your item data to JOOR. This criteria, which can be an existing or new custom field, will be used by the JOOR x NetSuite connector to:

• Fetch and sync the appropriate item data from NetSuite to create or update it in JOOR.
• Delete product data on JOOR that no longer meets the defined NetSuite criteria.

Examples of criteria include:

• An existing custom field used to categorize items or define their scope (e.g., wholesale channels).
• A new custom field, such as a "JOOR Enabled" checkbox.

Items will sync ...

📘

Note:

Items with no parent, no child, but have Color & Size information will be created both as a Product and as a SKU for that Product.

...as Products when:

The Item:

• is without a Parent Item,
• is without any Child Items,
• but has Color & Size information

OR

The Item:

• is without Parent,
• but has Child Items

...as SKUs when:

The Item:

• is without a Parent Item,
• is without any Child Items,
• but has Color & Size information

OR

The item:

• is with a Parent Item,
• is without any Child Items,
• but has Color & Size information

❓

Q&A:

How do we map the wholesale and retail price types from NetSuite to JOOR? Price types in NetSuite map to price types in JOOR. Wholesale and retail figures sync accordingly.

Can we select the price types we want to sync to JOOR? Yes, you can select the price types to sync to JOOR. Your mapping file will reflect your selections.

Can I sync casepacks? Casepacks are not currently supported.

Where do I see if the data sync generated errors? JOOR is currently working on a basic monitoring page's implementation.

Can I force re-sync items selectively outside of the scheduled jobs? The JOOR - NetSuite connector syncs hourly. No forced re-sync functionality is currently available.

Prices

Price sync is customizable. See Mapped Fields - NetSuite for details.

❓

Q&A:

Can we have multiple price types for the same Product/SKU? Yes. Multiple price types are supported.

How do we map the wholesale and retail price levels from NS to JOOR? Price types in NetSuite map to price types in JOOR. Wholesale and retail values sync accordingly.

Can we select the price types to sync to JOOR? Yes, your JOOR Integrations Manager will guide you in selecting the price types to synchronize with JOOR.

Images

The entire NetSuite File Cabinet (NFC) is considered during syncing. There is no need to assign images to Items directly.

JOOR will automatically match existing images in the NetSuite File Cabinet that match a specific filename pattern. This filename naming convention is configurable and will be established during the set up.

🚧

Though the naming convention is customizable, it is necessary to consistently adhere to whichever naming convention you choose. Take this into consideration when determining your naming convention.

❓

Q&A:

Can I sync style images, style color images and swatches? Yes, images stored in your NetSuite File Cabinet can be synced to JOOR. The image filename must be consistent (e.g., product_code+color+position) and shared with your Integrations Manager during the project.

How do I update/replace an image through the integration? Update the item in NetSuite and save it to trigger the image update/replacement.

Collections

See Mapped Fields - NetSuite for details.

by default

The recommended method for managing your collections in JOOR is to use the native NetSuite Item Collection feature. This functionality allows you to easily group items for sale.

Once the Item Collection has synced, supplementary details such as Season and Delivery Window should be set directly within JOOR.

with mapping customization

If the standard NetSuite Item Collection feature is not suitable for your workflow, and you currently manage seasons and collections using custom item fields, you can use those fields to populate your JOOR collections. Please inform your JOOR Integrations Manager of this preference.

❓

Q&A:

How do I sync Collections to JOOR? The recommended method is to use the native Item Collections object in NetSuite, which can be accessed by navigating to List > Accounting > Item Collection.

How can I drop a style from a linesheet? Removing a style from the Item Collection will remove it from your JOOR linesheet.

Can I sync more than one Collection? Yes, you can add an item to multiple collections. If needed, you can even be more specific and assign individual SKUs (e.g., excluding certain colors) to different collections.

Can I set Collection delivery dates? The standard Item Collection object in NetSuite does not support delivery date fields. Therefore, delivery dates must be set manually in JOOR after the initial sync. If you have a custom NetSuite object that contains this information, its delivery date fields can be configured to sync automatically via your connector.

Inventory

See Mapped Fields - NetSuite for details.

Immediate Inventory, by default

NetSuite Product Availability information will sync with JOOR Inventory.

Multiple location/bins can be synced to JOOR.

Future Inventory, with mapping customisation

If you've established a Future Inventory process in your NetSuite account and wish to integrate this data with JOOR, inform your JOOR Integrations Manager. JOOR can accommodate this by setting up a custom solution to populate your future inventory.

❓

Q&A:

Can I sync inventory from multiple warehouses? Yes

Does my inventory overwrite or update whenever I sync it to JOOR? The JOOR - NetSuite connector overwrites current inventory.

Can I sync future inventory? Yes, this is possible through a custom data mapping.

Connections/Customers

See Mapped Fields - NetSuite for details.

When Customers will sync to JOOR?

You will collaborate with your JOOR Integrations Manager to define the criteria for synchronizing your customer data to JOOR. The JOOR x NetSuite connector will use this criteria—an existing or new custom field—to fetch and create or update customer records in JOOR.

Examples of this criteria include:

• An existing custom field used to categorize customers or define their territory (e.g., USA, Europe).
• A new custom field, such as a "JOOR Enabled" checkbox

❓

Q&A:

Can we have multiple price types for the same customer? Only one price type can be assigned to a single customer.

Can I sync customer discounts? Will it be at header or line item level? Discounts should be included in the price type. Any additional discounts will require custom development.

Will a customer record on NetSuite be created upon order import on NS for orders I placed for new customers on JOOR? The recommended workflow is to create the customer in NetSuite and sync it to JOOR before any orders are exported. If your business needs a different approach, your Integrations Manager will assist you with the required setup.

Where do I see if the data sync generated errors? Data sync error reports for customers can be received via email.

Can I force re-sync customers selectively outside of the scheduled jobs? No. The JOOR - NetSuite connector syncs hourly.

Orders

NetSuite sales orders will sync with JOOR Orders.

See Mapped Fields - NetSuite for details.

❓

Q&A:

Can I update already imported orders on JOOR? Yes, following these steps:

• Delete the order in NetSuite
• Update the order in JOOR
• Set the order to re-export in JOOR

If my orders fail to import, how do I re-import it? The export status will display the error description. To re-export the order immediately after resolving the issue, click the provided link. Alternatively, the order will automatically re-attempt to export during the next scheduled run.