The data flow ‘NetSuite Item to eBay Item Add/Update’ automatically exports NetSuite simple inventory items as listings on eBay. Product catalogs can be maintained inside NetSuite while the data flow keeps the items always in sync in eBay (whenever a new item is created or an existing item is updated in NetSuite). The Integration App supports the following item types: Inventory item, Kit/package, Assembly/Bill of Materials.
Items created in NetSuite are exported to eBay in batch flows. The Integration App can be configured to also transfer items in scheduled intervals. Several options are provided in the Integration App dashboard to set up and modify the data flow as per your business.
Before you start exporting items, you must complete the following set-up in NetSuite (steps are followed by sample screenshots):
- Map mandatory eBay listing attributes
- Add eBay listing Categories in NetSuite
- Select Default Values for eBay listing
- Map Item Specifics for eBay listings.
- Set eTail channel (as eBay) and select Account Name under eTail sub-tab in NetSuite Item record.
- Run the data flow in the Integration App to export the item to eBay.
The above steps are depicted by the following sample screenshots:
- Map mandatory eBay listing attributes (e.g eBay Condition, Images etc.). More details can be found at the end of this article.
- Add custom fields in NetSuite for these attributes, if not already present.
- Add these fields as Results/Columns in the Item Export Saved Search in NetSuite.
- Add custom fields in NetSuite for these attributes, if not already present.
- Add Item Categories in NetSuite.
- Identify the eBay (category name, category id) for the categories being sold in. (click the item and see the category name / open child category and see a number in URL, when the item is opened).
The number is visible in the URL. - Add these categories into NetSuite - ‘eBay Category - Primary’ field under eTail sub-tab on Item record.
- Identify the eBay (category name, category id) for the categories being sold in. (click the item and see the category name / open child category and see a number in URL, when the item is opened).
Please see How to Obtain eBay Categories and Category IDs for assistance with IDs.
- Select Default Values for eBay listings.
Find the settings under “Item Defaults” tab under Advanced Settings section - Map Item Specifics for eBay listings.
Item specifics allow you to provide extra information about your products in a structured manner. Also, eBay mandates a few item specifics depending on the categories you are the listing the items in. So, we recommend you to check which item specifics are mandatory for a given category. Refer to the attachments at the end of this article to find eBay Mandatory Category Specifics for USA and Canada. Example - the following item specifics are mandatory for T-shirts.
eBay Category Id
eBay Category Name
Item specifics Label
Recommended Values
63869
T-Shirts
Style
Basic Tee,Embellished Tee,Graphic Tee,Personalized Tee
63869
T-Shirts
Size Type
Regular,Petites,Plus,Juniors
63869
T-Shirts
Size (Women's)
2XS,XS,S,M,L,XL,2XL,3XL,4XL,5XL,6XL
- Set up fields in the eTail tab of the NetSuite Item. Select ETAIL Channel and Add eBay Category Primary.
- Run flow from the data flow.
From Settings section and view status of the flow in the dashboard.- Data flow Dashboard displays the status of the flows.
- Once the flow is successful, the item is moved into eBay.
- Data flow Dashboard displays the status of the flows.
Mandatory attributes for eBay Item Export & How to Map them?
The following mappings are provided by default
- SKU
- Item Name / Number field in NetSuite is mapped to Listing Custom Label in eBay.
- Title
- Item Title field in NetSuite is mapped to Listing Title in eBay.
- Description
- Item Description field in NetSuite is mapped to Listing Description in eBay. This can be text or HTML content. If it is HTML content, it is recommended to store it in a rich text field in NetSuite.
- Item Price
- Item Unit Price in NetSuite is mapped to Listing Price in eBay.
- Category ID
- The custom field on the NetSuite Item record - 'eBay Category - Primary' is mapped to Listing Category in eBay. This field is already bundled with the Integration App, available under eTail tab / eBay sub-tab.
The following mappings are not provided in the Integration App
The below mappings are not provided in the Integration App. Settings are available for most of these eBay listing attributes on IO to provide default values. If required, you can configure the mappings for these fields in the eBay Item Export Saved Search in NetSuite. If these attributes are not mapped to NetSuite fields (using the Saved Search) OR if they were mapped but they do not have any values for a given Item in NetSuite, then the Integration App assigns the default values (configured in IO settings) and exports the Items to eBay.
- Images
- eBay accepts publicly accessible URLs for Images. Each listing must have one main image and optionally multiple alternative images. Image mappings are not provided with the Integration App. The customer is responsible for mapping these fields in the Item Saved Search. Refer to the section below on how to configure Images.
- Currency
- Currency should match the eBay Site, e.g. eBay US = USD
- Country
- The Country in which the seller account is registered.
- Listing Duration
- How long you want the eBay listing to be active (e.g 1 Day, 10 Days, GTC - Good Till Cancelled). Generally, GTC is recommended for Professional sellers.
- Item Location
- Zip code of Item's location, usually the location of the warehouse.
- Item Condition
- The condition of the Item - e.g New, Used etc.
- Payment Policy Id
- Id of the Payment Policy on eBay. Read more about Business Policies here
- Return policy Id
- Id of the Return Business Policy on eBay. Read more about Business Policies here
- Shipping Policy Id
- Id of the Shiping Business Policy on eBay. Read more about Business Policies here
- Weight
- Weight of the Item in Pounds - This is Mandatory only for some Shipping Carriers/Policies.
- Weight of the Item in Pounds - This is Mandatory only for some Shipping Carriers/Policies.
Configuring Images
Images can be stored in NetSuite in any one of the following two ways:
- Create a custom field of type textbox for item record and store the item Image URL in that field.
- Create a custom field of type Image for item record. Attach Image from Netsuite File System.
For mapping more Images, add extra columns to the eBay Item Export saved search in NetSuite. But make sure that the Custom Label of the column must be named as "Images" only for all the new columns. The first column (with 'Images' label) in the saved search is considered as Main Image and rest of them as alternative images in the same order as they appear in the saved search.
Best Offer Configuration
- Create three custom fields on item Record
- Best Offer Enabled - type: CheckBox
- Minimum Best Offer Price - type: text
- Best Offer Auto Accept Price - type: text
- Replace existing columns on saved search with three fields
- Sample Existing Saved Search screen
- Saved Search after replacing those fields
- Sample Existing Saved Search screen
Additional Order fields that can be mapped
- CheckOut Message - The message that the buyer has provided during checkout.
- BuyerUserId - Unique Id identifying the buyer on eBay.
Comments
0 comments
Please sign in to leave a comment.