The easiest way to make sure your products get uploaded properly is to download a sample file in the Wiseboard by clicking the blue Import Products button and retrieving a sample CSV:
The mandatory fields vary between marketplace types.
Here we go over all fields in the CSV template:
Product Name: The title of the product
Inventory Number: The SKU (this is the unique identifier in our system so typically this is your internal SKU number)
IN STOCK: How many items are in stock, often referred to as 'Available'
UPC/EAN: The UPC / EAN (ISBN and GTIN are acceptable)
ASIN: The ASIN or ISBN 10 (for books on Amazon) - this is specific for Amazon
Brand: Brand / Manufacturer
Model: Item's model #
MPN: The Item's Manufacturer Part Number
Product Price: The current price on your store
Minimum Price: The lowest price you are willing to sell this item
Maximum Price: The highest price you are willing to sell this item (this is to prevent one competitor driving all prices up)
Cost: Your cost. This is useful for margin calculation, and to apply certain price guards
Shipping Price: This is the amount you charge for shipping (not your cost).
Product URL: The URL for the item on your website
Image URL: A link to a thumbnail image of the product. For visual purposes in the Wiseboard.
Labels: Labels are the most useful field for large catalogs. Here you can group items and make filters using this field. An example for a 'Labels' value could be: "Accessories, Supplier A, Top-Seller, Season: Winter"
MSRP: Manufacturer Suggested Retail Price (not typically necessary)
Unit Count: How many units you have (not typically necessary)
Condition: The condition of the item, i.e. ‘New’, ‘Used’, or ‘Refurbished’. Only necessary if you carry used items, otherwise ignore. (not typically necessary)
ePid: eBay Product ID - when available (for example eBay Motor)
Category: Category that the SKU falls in. This is also helpful when creating filters for pricing rules and analyses.
Mandatory fields for a non-integrated store:
Product Name
Inventory Number/SKU
Product Price
‘Minimum Price’ or ‘Cost’
‘UPC/EAN’ or ‘Brand + MPN’ or ‘Brand+Model’ (the more the better)
ASIN if your contract includes Amazon domain
Mandatory fields for an Amazon store:
Product Name
Inventory Number / SKU
Product Price
‘Minimum Price’ or ‘Cost’
ASIN
Mandatory fields for an eBay store:
Product Name
Inventory Number / SKU
Product Price
‘Minimum Price’ or ‘Cost’
‘UPC/EAN’ or ‘Brand + MPN’ or ‘Brand+Model’ (the more the better)
Troubleshooting CSV Uploads:
The Google Chrome browser tends to work best when uploading CSV's. Please keep in mind that clearing your cache can also be a good place to troubleshoot.
If you are unable to import a CSV into the Wiseboard, please perform the following checks in the file:
Save the file in CSV-UTF-8 format.
All Price columns are Currency, 2 decimals, no symbol.
All numerical columns (UPC, Inventory Number/SKU, MPN, ASIN, Model, etc…) are formatted correctly. No scientific notations.
There is no period (.) in a column name.
There are no special characters or non UTF-8 characters in the file (open the file in the text editor to confirm this step since Excel doesn’t show any special characters or non UTF-8 characters).
Verify quotes in product name/description and make sure to escape those characters using a backslash (\). If escaping is not possible, just remove the double quotes from the file using find and replace.
Check to ensure there is no additional information in the file with no column name.