Product Catalogue Template

The default file template is in a CSV format. You can always download an up to date sample file from our upload screen.

  • Click on Actions
  • Import from File
  • Select ‘Download Sample File’

 

After selecting the 'Import products from file' link, select the CSV you wish to upload and hit the orange 'Upload' button.

Here, make sure that each field is aligned correctly with its respective title. You may refer to things differently, i.e. 'Brand' as 'Make' or 'Product Name' as 'Title'. 

**Make sure the 'Ignore Empty Fields' button is checked.

 

The default file template is in a CSV format. You can always download an up to date sample file from our upload screen.

  • Click on Actions
  • Import from File
  • Select ‘Download Sample File’

FTP users also need to be mindful of file names, as they need to be named very specifically before they are dropped into the Uploads folder. For more information on FTP integration, please refer to this tutorial.

You can drop the daily input file in the Upload folder and there will be a daily output file (with the new price, and competitors data) in the Download folder.

For the upload, the file name should be WP_Inv.csv 

The file name cannot be changed (so you will overwrite the old file every upload).

Also, the column headers in the file must be identical to the ones in our upload template. Otherwise, the file will not be mapped properly.

If you have multiple stores, each upload file will have to have a unique Store ID in the file name.

For example: WP_Inv_000000.csv – Your store ID’s will be provided to you upon setup.


WisePricer also supports TSV files, or Tab-Delimited Value files. If you would prefer to use a TSV instead of a CSV, download our TSV file that is attached to this article. TSV's are simply CSV's delimited by a tab instead of a comma, and is also supported by excel. If your computer asks what program to use to open the TSV file type with, select Excel and it should open correctly. The naming conventions for a TSV file are identical to the CSV files, it's important that you change the "C" in CSV to a "T". 

For the upload, the file name should be WP_Inv.tsv 

The file name cannot be changed (so you will overwrite the old file every upload).

Also, the column headers in the file must be identical to the ones in our upload template. Otherwise, the file will not be mapped properly.

If you have multiple stores, each upload file will have to have a unique Store ID in the file name.

For example: WP_Inv_000000.tsv – Your store ID’s will be provided to you upon setup.

The mandatory fields vary between marketplace types. Here we go over all fields in the CSV template (directions to import and map fields can be downloaded here

 

 

CSV Header

Description

Condition

The condition of the item, i.e. ‘New’, ‘Used’, or ‘Refurbished’. Only necessary if you carry used items, otherwise ignore.

Product Name

The title of the product

Inventory Number

The SKU

IN STOCK

How many items are in stock, often referred as 'Available'

UPC/EAN

The UPC / EAN (ISBN and GTIN are acceptable)

ASIN

The ASIN or ISBN 10 (for books on Amazon)

ePid

eBay Product ID - when available (for example eBay Motor)

Make

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
merchant 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). 
If you don't charge flat rate shipping, please use a zip code in Chicago
as we reference the Mid-West when comparing total prices

Product URL

The URL for the item on your webstore

Image URL

A link to a thumbnail image of the product.
For visual purposes (and if enabled for image recognition price match)

Labels

Labels are the most useful field for large catalogs. 
Here you can group items. 
An example for a 'Labels' value will be: "Accessories, Supplier A,
Top-Seller, Season:Winter"

Mandatory fields for a Webstore store:

  • Inventory Number / SKU
  • Product Name
  • Product Price
  • ‘Minimum Price’ or ‘Cost’
  • ‘UPC/EAN’ or ‘Brand + MPN’ or ‘Brand+Model’ (the more the better)
  • ASIN if you'd like to include Amazon competitors as well

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)
  • ePID – if available 

Help Us Get Better

Was this article helpful?

0 out of 0 found this helpful

Your problem isn't listed here?

Ask a Question
Have more questions? Submit a request

Comments