How to assemble your product catalog in a CSV file for upload

Assembling your product catalog can be time-consuming. Here is some help.

Your product catalog must be submitted to Reviewbox in a comma-delimited text file, known as a CSV file. Here is a guide to help you quickly pull together the information you need to get your product catalog into Reviewbox.

We're here to help. Please contact support@getreviewbox.com for assistance any time.

Lay out the product catalog in a spreadsheet

Required information

The CSV file must contain at least two columns: source and id. These columns must be in this order and they must be spelled correctly. There should be one row for each product listing. 

An example of some CSV file column headings is shown below.

source id min max Business Unit Brand Model Number

source – This field specifies the retail site where the product listing appears. The source code must match our list of supported retailers. For example, Walmart.com is represented as ‘walmart’, Amazon.com is ‘amazon’, and Amazon Canada is ‘amazon.ca’. You can find the complete list of retail sources and their abbreviations below.

id - This ID is the specific identifier used by a retailer to identify your product. For Amazon.com, this is the ASIN. For other retailers, use the most specific identifier available, such as the variation ID. Often these are specific to the color, size, or other variation of the parent product. For guidance on how to find the IDs for your products, see How to locate listing IDs.

A Bulk Upload template is available here: bulk-listings-upload-template.csv.

Optional fields

min and max: these fields are used by Pricebox and they specify the minimum and maximum acceptable MAP prices. Blank cells are allowed in the min and max columns.

Custom Fields: In the example above, Business Unit, Brand, and Model Number are Custom Fields. You may want to include your own custom fields, as described in the Help Center under What are Custom Fields? You may leave blank cells in the custom fields if necessary, but not in the source or id columns.

Save your spreadsheet as a CSV file

One easy way to generate a CSV file is to use the ‘Save As’ capability in Excel or other spreadsheet to save the CSV file.

save as csv

You can also save as a CSV using Python, R, or any text editor.

Troubleshooting

If you have trouble uploading your file, check these common issues:

1. Please check that you have saved the file with the UTF-8 character encoding. 

2. You should not have any blank cells or missing information in the source or id columns

Retailer 'source' codes

The list is also available here: sources.csv

Retail Site

source code

Academy Sports

academysports

AceHardware

acehardware

Amazon

amazon

Amazon AU

amazon.au

Amazon CA

amazon.ca

Amazon CN

amazon.cn

Amazon DE

amazon.de

Amazon ES

amazon.es

Amazon FR

amazon.fr

Amazon IN

amazon.in

Amazon IT

amazon.it

Amazon JP

amazon.jp

Amazon MX

amazon.mx

Amazon UK

amazon.uk

Apple Store

applestore

Argos

argos

Bass Pro

basspro

BazaarVoice

bazaarvoice

BedBath and Beyond

bedbathbeyond

Best Buy

bestbuy

Best Buy CA

bestbuyca

Build

build

Cabelas

cabelas

Cabelas

cabelas

CanadianTire

canadiantire

Chapin

chapin

Chewy

chewy

Costco

costco

Costco CA

costcoca

CVS

cvs

Defender

defender

Dicks

dicks

Dunelm

dunelm

eBay

ebay

Game Stop

gamestop

Google Shopping

google

Grainger

grainger

Hayneedle

hayneedle

HomeDepot

homedepot

HomeDepotCA

homedepot.ca

Houzz

houzz

Iherb

iherb

Jet

jet

Lowes

lowes

LowesCA

lowes.ca

Michaels

michaels

New Egg

newegg

Office Depot

officedepot

OverStock

overstock

Petco

petco

Petsmart

petsmart

REI

rei

RuralKing

ruralking

Sainsbury UK

sainsburyuk

SamsClub

samsclub

Staples

staples

Staples CA

staplesca

Target

target

TractorSupply

tractorsupply

Walgreens

walgreens

Walmart

walmart

Walmart CA

walmart.ca

Wayfair

wayfair

Wayfair CA

wayfairca

Wayfair DE

wayfairde

Wayfair UK

wayfairuk

Wegmans

wegmans

West Marine

westmarine