Integration Overview - NetSuite
Integration | Developed By | Integration Type | Products & SKUs | SKUs Prices | Collections | Images | Inventory | Connections | Orders |
---|---|---|---|---|---|---|---|---|---|
NetSuite | JOOR | API | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
Products & SKUs
NetSuite Items will be synced as either Products or SKUs depending on associated information.
When Items will sync to JOOR?
You'll define with your JOOR Integrations Manager how you want your items data to sync to JOOR. This criteria, which can be:
- an existing custom field that you use to categorise items, or define their scope (ie: wholesale channels, ...)
- a new custom field, like a "JOOR Enabled" checkbox,
will be used by the JOOR x NetSuite connector to:
- fetch the appropriate items data from NetSuite to create or update it in JOOR
- delete the products data on JOOR that does not follow this NetSuite criteria anymore.
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 levels from NS to JOOR?
Price types in NetSuite map to price types in JOOR. Wholesale and retail figures sync accordingly.Can we select the price levels we want to sync to JOOR?
Yes, will be defined during the project and reflect on the mapping.Can I sync casepacks?
This is not supported at the moment.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?
No.Do I need to pay if I am to request a customisation to our integration?
Please discuss this point with your JOOR Integrations Manager / JOOR Integrations Lab.
Prices
Price sync is customisable. See Mapped Fields -NetSuitefor details.
You'll determine with your JOOR Integrations Manager the Price Lists to sync with JOOR.
Q&A:
Can we have multiple price types for the same Product/SKU?
YesHow 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 figures sync accordingly.Can we select the price levels we want to sync to JOOR?
Yes, will be defined during the project and reflect on the mapping.Do I need to pay if I am to request a customisation to our integration?
Please discuss this point with your JOOR Integrations Manager / JOOR Integrations Lab.
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 NFC 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 customisable, 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, using the NetSuite File Cabinet. Image filename must be defined and agreed during the project
e.g. product_code+color+positionHow can I update/replace an image through the integration?
Update an item before it triggers the image update.
Collections
See Mapped Fields -NetSuitefor details.
by default
We suggest you use the NetSuite Item Collection feature to manage the Collections in JOOR. This native feature can be easily used to regroup the items as you would like to sell them directly in JOOR.
JOOR Collections' additional information (Season and Delivery Window) will be set once on JOOR after the Item Collection has synced.
with mapping customisation
If the NetSuite Item Collection feature is not suitable for you, and if you already manage your seasons and collections using custom items fields in NetSuite, then please inform your JOOR Integrations Manager as these fields can be used to populate the Collections in JOOR
Q&A:
How do I sync Collections to JOOR?
Using by default the Item Collections in NetSuite (List > Accounting > Item Collection)How can I drop a style from a linesheet?
By removing it from an Item CollectionCan I sync more than one Collections?
Yes, you can add an item to as many collections as you want in order to assign it to multiple collections.
Potentially at SKU level, excluding certain colors.Can I set Collections delivery dates?
No, these fields are not available on NetSuite Item Collection. These will have to be set manually on JOOR after the collection is created.
Inventory
See Mapped Fields -NetSuitefor 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 have set up a Future Inventory workflow/process within your NetSuite account and are keen to integrate this data to JOOR, then please inform your JOOR Integrations Manager as JOOR offers the possibility to populate the future inventory based on some customisation.
Q&A:
Can I sync inventory from multiple warehouses?
YesDoes my inventory overwrite or updates whenever I sync it to JOOR?
It overwrites.Can I sync future inventory?
Yes, this is possible on demand (data mapping customisation)
Connections/Customers
See Mapped Fields -NetSuitefor details.
When Customers will sync to JOOR?
You'll define with your JOOR Integrations Manager how you want your customers data to sync to JOOR. This criteria, which can be:
- an existing custom field that you use to categorise customers, or define their area (ie: USA, Europe, ...)
- a new custom field, like a "JOOR Enabled" checkbox,
will be used by the JOOR x NetSuite connector to fetch the appropriate customers data from NetSuite to create or update it in JOOR
Q&A:
Can we have multiple price types for the same customer?
Just one for customersCan I sync customer discount? Will it be at header or line item level?
Discount should be included in the price level. If extra discount is required, will be developed.Will a customer record on NetSuite be created upon order import on NS for orders I placed for new customers on JOOR?
No. The customer must exist before the order imports.Where do I see if the data sync generated errors?
Data sync error reports for customers can be received over emails.Can I force re-sync customers selectively outside of the scheduled jobs?
No.Do I need to pay if I am to request a customisation to our integration?
Please discuss this point with your JOOR Integrations Manager / JOOR Integrations Lab.
Orders
NetSuite sales orders will sync with JOOR Orders.
See Mapped Fields -NetSuitefor 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 force re-import it?
Export status will show the error description. Please fix it and the order will attempt at exporting on the next run automatically.
Updated 20 days ago