The NetSuite Item to eBay Item Add/Update flow in the eBay - NetSuite integration app creates eBay listings from NetSuite items and keeps them updated when the items change, so you maintain your product catalog in NetSuite only. This article covers how to set up items and the flow, the product settings, which listing attributes are mapped by default, and how to send images, weights, best offer details, and product identifiers to eBay. The product flows are part of the Standard edition.
Prerequisites:
- Mark each item for eBay. For details, see How NetSuite items are linked to eBay listings.
- Set the eBay category for each item. For details, see Assign eBay categories to NetSuite items.
How the product flow works
The flow sends new and changed NetSuite items to eBay as listings. It runs on a schedule that you set, or when you run it. Each time it runs, the dependent eBay ItemID to NetSuite item (update) flow saves the eBay item ID back on the NetSuite item.
These item types are supported: inventory items, kit or package items, and assembly or bill of materials items.
Set up items for eBay listings
- Make sure each mandatory eBay listing attribute has a value, either from a NetSuite field or from a default in the product settings. If an attribute isn't in NetSuite, add a custom field for it and add the field as a column in the item export saved search. For the attributes, see Listing attributes.
- Go to Settings > Product > General, select the NetSuite saved search for syncing items, and map your item specifics. For details, see Product settings.
- Go to Settings > Product > Default Options, set the default values for listing attributes that aren't in NetSuite, and then select Save.
- Run the NetSuite Item to eBay Item Add/Update flow.
When the flow completes, the items are listed on eBay.
Product settings
Product settings are under Settings > Product, on two tabs.
General
| Setting | Description |
|---|---|
| NetSuite saved search for syncing items | The NetSuite saved search that selects the items to list. Select Refresh to load the latest saved searches. |
| Map Item Specifics | Maps eBay item specifics to NetSuite item fields. For each, enter the eBay Item Specific Label as text, and the internal ID of the NetSuite item field in NetSuite Field Id. |
| Map Variation Specifics | Maps eBay variation specifics to NetSuite item fields, in the same way. For details, see Sync matrix items and virtual variations to eBay. |
| Add GST/VAT to item price | Adds GST or VAT to the item price before it's sent to eBay. For details, see Handle GST and VAT for eBay orders and listings. |
| Enable virtual variations | Select this if you set up parent and child items without NetSuite's matrix item feature. For details, see Sync matrix items and virtual variations to eBay. |
Item specifics give buyers structured details about a product. eBay requires some item specifics for some categories, so check which are mandatory for the categories you list in. For example, eBay requires these for T-shirts (category ID 63869):
| Item specific | Recommended values |
|---|---|
| Style | Basic Tee, Embellished Tee, Graphic Tee, Personalized Tee |
| Size Type | Regular, Petites, Plus, Juniors |
| Size (Women's) | 2XS, XS, S, M, L, XL, 2XL, 3XL, 4XL, 5XL, 6XL |
Default options
The default options are used only for items that don't have a value for the attribute in NetSuite.
| Setting | Description |
|---|---|
| Default Item Condition | The item condition, such as New. For the values, see Item condition IDs and names. |
| Default Listing Duration | How long listings stay active. The GTC (good till canceled) duration is recommended, especially for professional sellers. For the values, see ListingDurationCodeType. |
| Default Payment Policy Id | The ID of your eBay payment business policy. For how to find it, see Find eBay business policy IDs. |
| Default Shipping Policy Id | The ID of your eBay shipping business policy. |
| Default Return Policy Id | The ID of your eBay return business policy. |
| Default Currency | The currency of the eBay site you list on, for example US Dollar for eBay US. |
| Default Country | The code of the country where your seller account is registered. For the codes, see CountryCodeType. |
| Default Item Location | The postal code where your items are located, usually your warehouse. |
Listing attributes
The integration app maps these NetSuite fields to eBay listing attributes by default:
| eBay listing attribute | NetSuite field |
|---|---|
| Custom label (SKU) | Item name or number |
| Title | Item title (display name) |
| Description | Item description, as text or HTML. Store HTML in a rich text field. |
| Price | Item unit price |
| Category | eBay Category - Primary, a custom field installed with the bundle on the eTail subtab, under eBay |
These attributes aren't mapped to NetSuite fields by default. If the item export saved search doesn't map them, or an item has no value, the integration app uses the default from Settings > Product > Default Options:
- Images: No default; you map images yourself. For details, see Send item images.
- Default Currency: Must match the eBay site, for example USD for eBay US.
- Default Country: The country where your seller account is registered.
- Default Listing Duration: How long the listing stays active, for example 1 day, 10 days, or GTC.
- Default Item Location: The postal code of the item's location.
- Default Item Condition: For example, new or used.
- Default Payment Policy Id, Default Shipping Policy Id, and Default Return Policy Id: The IDs of your eBay business policies.
- Weight: Required only by some shipping carriers and policies. For details, see Send item weights.
To take an attribute from NetSuite instead, add the NetSuite field as a column in the item export saved search.
Send item images
eBay accepts images as publicly accessible URLs. Each listing needs one main image and can have more. You can store image URLs in NetSuite in either of these ways:
- A custom item field of type text that holds the image URL.
- A custom item field of type image, with the image attached from the NetSuite file cabinet.
Add each image field as a column in the item export saved search, with the custom label Images. Use Images for every image column. The first Images column is the main image, and the others are additional images in the order they appear in the saved search.
Send item weights
The item export saved search sends weight in two columns: pounds (Weight In Pounds, mapped to ShippingPackageDetails.WeightMajor) and the remaining ounces (Weight In Ounces, mapped to ShippingPackageDetails.WeightMinor). If your items use different weight units, use these formulas in the two columns to convert them.
Weight in pounds (major):
floor(round(case {weightunit} when 'kg' then {weight}*35.274 when 'lb' then {weight}*16 when 'oz' then {weight} when 'g' then {weight} * 0.035274 end,0) / 16)Remaining weight in ounces (minor):
mod(round(case {weightunit} when 'kg' then {weight}*35.274 when 'lb' then {weight}*16 when 'oz' then {weight} when 'g' then {weight} * 0.035274 end,0),16)Set up best offers
- In NetSuite, create three custom item fields: Best Offer Enabled (check box), Minimum Best Offer Price (text), and Best Offer Auto Accept Price (text).
- In the item export saved search, replace the existing best offer columns with these fields, keeping the custom labels Best Offer Enabled, Minimum BestOffer Price, and BestOffer AutoAccept Price.
Find eBay business policy IDs
Every eBay listing must have a payment policy, a shipping policy, and a return policy. You manage them in your eBay seller account. If business policies aren't turned on for your seller account, contact eBay support.
- Sign in to your eBay seller (production) account, and go to My Account > Business Policies.
- Select the policy.
- Copy the profile ID from the page URL. For example, a payment policy whose URL contains
5056340022has the policy ID5056340022.
Send EAN product identifiers
eBay requires a product identifier on each listing. By default, the integration app sends the UPC. To send the EAN (European Article Number) instead:
- In NetSuite, edit the Celigo eBay Item Export Search saved search.
- On the Results subtab, under Columns, add the field that holds the EAN, such as a custom EAN Code field, with the custom label
EAN. - In the integration app, go to Flows > Product, and select Mapping for NetSuite Item to eBay Item Add/Update.
- Map
EANtoProductListingDetails.EAN, and then select Save. - In the preview, search for the EAN value to confirm that the saved search returns it, and then select Save & close.
Send eBay product IDs (ePID)
In some categories, eBay groups listings by product, and listings must include an eBay product ID (ePID) to stay visible to buyers. The integration app adds an EBAY PRODUCT ID field to the NetSuite item, on the eTail subtab under eBay, and maps it to ProductListingDetails.ProductReferenceID. Enter the ePID in this field for each item listed in these categories. Without an ePID, the flow can't add or revise listings in those categories.
To find the ePID for an existing listing, as the eBay account administrator:
- Sign in to eBay, and search for the listing's item ID. Make sure the item doesn't have multiple SKUs or variations.
- Select Find a Product next to the listing title, and enter a title, MPN, or GTIN (UPC, ISBN, or EAN).
- Select the product that matches your item. The ePID is in eBay's product catalog description.
For a new listing, select Sell on eBay, enter a title, manufacturer part number, or global trade item number, and select the matching product to see its ePID.