Whenever an item is created or updated in Netsuite, the integration app syncs the information from NetSuite into BigCommerce. The flow supports both simple and matrix item types. In the case of Matrix Items, the parent matrix item is exported as BigCommerce Product while the child matrix items are exported as variations for the same product in BigCommerce. However, Assembly, Kit Item types are not supported by this flow.
When you run the "NetSuite Item to BigCommerce Product Add/Update" flow, you can select a start date to pull the historical data. On the pop-up window, you can either select:
- Automatic: Choose this option to process and sync data from the last flow run time.
- Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
Before you sync an Item from NetSuite to BigCommerce, you must sync product categories from BigCommerce to NetSuite. For instructions, see Importing Product Categories from BigCommerce to NetSuite.
Sync simple Items from NetSuite to BigCommerce
- In NetSuite, create a new item or find an existing item.
- Under the "eTail" tab, select the ETAIL CHANNEL as BigCommerce & provide appropriate values for the rest of the BigCommerce Specific fields like Item Category, Store, etc.
- Save the Item record.
- In integrator.io, navigate to the Settings page for the BigCommerce - NetSuite integration app and under Product, click the Run button for the NetSuite Item to BigCommerce Product Add/Update flow.
- Once the flow is successfully completed, verify that the item is exported to BigCommerce in the 'Products' section.
Advanced settings
- NetSuite Saved Search for syncing item details: The drop-down list displays the saved search pertaining to item export that is created in NetSuite. Select the desired saved search from the list. Click Refresh to fetch the items that have not been imported from NetSuite to BigCommerce.
- NetSuite price level for syncing product price: Lets you choose the NetSuite price level to be used for exporting the price to Bigcommerce.
- NetSuite currency for syncing product price: Lets you choose the NetSuite currency to be used for exporting the price to Bigcommerce.
Notes:
- This flow supports only Matrix items with up to 5 variation options.
- This flow is only supported by the standard (previously "premium") or premium (previously "enterprise") edition of the integration app.
Sync matrix items from NetSuite to BigCommerce
NetSuite Matrix Items are exported as Product variations in BigCommerce. The parent Matrix item is exported as BigCommerce Product while the child Matrix items are exported as variations for the same product in BigCommerce. The data flow supports Inventory matrix items and Assembly matrix items (Simple, Lot Numbered, Serialized) and also supports exporting a single NetSuite Matrix item to multiple BigCommerce stores.
The NetSuite Item to BigCommerce Product Add/Update flow also supports a feature "Virtual Variations" which allows you to create Product Variations in BigCommerce from Non-matrix items in NetSuite. For more information, see Setup parent-child relationship without NetSuite's Matrix Item functionality.
Creating BigCommerce Variation Themes
- In NetSuite global search box, type "New Celigo BigCommerce Variation Themes" or navigate to Customization -> List, Records, & Fields -> Record Types and find the custom record "Celigo BigCommerce Variation Themes".
- Create a new theme by providing a name (example Size - Color). For each Variation Option (aka attribute), provide an Option Name & Option Id and you can provide up to five options in a single variation theme.
- Option Name -> Corresponds to BigCommerce Option Label. For example any label such as Color, Size, Length, or Width.
- Option Field Id -> Should be the internal id of the corresponding Matrix Option Field in NetSuite.
Example: If a NetSuite Matrix Option field "Color" (internal id: custitem_color) is set up to include all the option values for color, then you need to provide the value of this field as custitem_color.
You can set up as many variation themes as you would like for your products and once a variation theme is created, you can assign the same one on as many products as you would like.
Select a variation theme on the NetSuite matrix Item
- In NetSuite, similar to the steps you took to export a simple item, an additional field "BigCommerce Variation Theme" under eTail -> BigCommerce should be populated on the Matrix Parent in addition to all the other field, eTail Channel, "BigCommerce Stores" etc
- Save the Matrix item record.
- In integrator.io, navigate to the Settings page for the BigCommerce - NetSuite Integration app and under Product, click the Run button for the NetSuite Item to BigCommerce Product Add/Update flow.
- Once the flow is successfully completed, verify that the item is exported to BigCommerce in the 'Products' section.
IMPORTANT: Assume that you have already created a majority of items in BigCommerce and ran the NetSuite Item to BigCommerce Product Add/Update flow. The integration app while syncing matrix items to BigCommerce always create duplicate items in BigCommerce and will not update the existing items that you have already created in BigCommerce. Whenever you export a new item in NetSuite that has a parent and child relationship, the integration app will always create a new product option in BigCommerce based on the variation theme configuration set in NetSuite for this item and ignores the existing product options in BigCommerce. The SKU, its different variants, and its variation theme setting in NetSuite will always be imported together. To overcome this creation of duplicates issue, we recommend you create an item in NetSuite with the same variation themes and options as created in BigCommerce, and sync the product id map to NetSuite so that duplicates are not created and existing ones are updated.
FAQs
How to map BigCommerce custom fields to NetSuite custom Item fields during Item export?
We expect you to create custom Item fields in NetSuite for the custom fields present in BigCommerce. Ideally, the custom Item field in NetSuite should have a name that you will be able to identify on the Mapping screen.
The following image describes the custom fields (Size and Color) created in BigCommerce.
The following image describes the Item custom fields (Custom Field 1 value and Custom Field 2 Value) created in NetSuite for the custom fields present in BigCommerce. We recommend that you add the custom fields to the NetSuite Saved Search that you use for executing the NetSuite Item to BigCommerce Product Add/Update flow.
The Item custom fields, when created in NetSuite, are available on the Mappings screen. You can use these fields to export Item information from NetSuite to BigCommerce. You will have to map the BigCommerce custom fields manually using the syntax custom_fields.<field name>. For example, custom_fields.Size. Here, the part which is next to “.” is considered as the name of the Custom field in BigCommerce.
- BigCommerce custom fields are not auto-populated on the Mappings window.
- By default, in NetSuite, if the custom field/field is empty, the field value gets automatically deleted in BigCommerce. However, if you want to prevent this, then on the Mappings window, click the gear icon for that field and select the Discard If Empty checkbox. This will discard the desired field and the existing value in BigCommerce remains unaffected.
How to discard custom fields when exporting records from NetSuite?
By default, in NetSuite, if the custom field/field is empty, the field value gets automatically deleted in BigCommerce. However, if you want to prevent this, then on the Mappings window, click the gear icon for that field and select the Discard If Empty checkbox. This will discard the desired field and the existing value in BigCommerce remains unaffected. In addition, you may also choose to configure a default action if required.
Does BigCommerce item export support HTML code?
The BigCommerce item export doesn't support HTML code. The integration app directly sends the data or information received from NetSuite to BigCommerce.
Comments
I believe that it would be helpful to include how to add custom Netsuite item fields. A few examples of custom Netsuite fields that I would like to sync to Bigcommerce are Product Size, Ingredients, and Product Specifications.
Hi Shane, thanks for your feedback. Our team has addressed the question you had, sorry it took so long :)
Hey Gogula,
I have created the custom field in netsuite but not able to export it into Bigcommerce with the mapping you provided. Any chance you can help me please.
Sahni Enterprises Thank you for writing to us. The QA team has verified your account mappings and NetSuite saved search columns. The team could not find any discrepancies. Can you please raise a support ticket with the sample item details where you are finding the issue.
Gogula,
I have solved my above problem. I am having issues with Variation theme syncing over. I have checked all the settings in integrator and followed the steps in netsuite scripts to make sure it is correct. I am getting an error saying "Failed to export Matrix Item#16718 | Matrix options missing for following Item(s): Item undefined Options (Colors)."
I have crated a record item field named "BC Color Variation" and created a list record for the different colors to choose from. I have selected the Matrix option and it defaults a multi-select option under the Matrix subtab for location of this field. I still get the same error.
Sahni Enterprises Discussed with the QA team, they need to debug more. Can you please log a support ticket for further verification.
Gogula,
I have logged a ticket. I got this response back:
"This error is due to the setup of the Variation Theme. Make sure you map there the Variant Options you're using/going to use. In this case the Color."
They were not clear if I need to map this in integrator or not. Also I don't have information on how to map it in integrator as it is not on this post.
Hi,
Pls refer the Creating BigCommerce Variation Themes section on this article on how to create Variation Themes in NetSuite. Ex - You'd create a new record for "Celigo BigCommerce Variation Themes" custom record and create an entry where Variation Option 1 (Name) is Color and Variation Option 1 (Field Id) is the NetSuite internal id for Color field (like custitem_color). Then you need to follow the steps under "Select a Variation Theme on NetSuite Matrix Item" section to select above variation theme on the item record and export it to BigCommerce.
I'd also inform support team of this so they can help you w/ any additional qs via the Support ticket. Hope this is helpful.
Hi Rohit,
I have done everything you have said, it still shows the error I mentioned above. I am not sure if there needs to be additional mapping done in Integrator to connect these variation fields.
Greetings,
This article looks like it references BigCommerce v2, is there an updated version for v3?
Hello Alex Amend
With the recent release to BigCommerce - NetSuite integration App, we have upgraded all the IA flows to support v3 endpoints of BigCommerce. You can review the release notes for the same here,
https://docs.celigo.com/hc/en-us/articles/4403619805197-BigCommerce-NetSuite-release-notes-v-1-15-0-July-2021
Please let us know for any further questions.
Please sign in to leave a comment.