Guide to Catalog Management in Reviewbox

Learn how to upload your product listings to Reviewbox and how to remove or update listings later.

1. Benefits of actively managing your product catalog

Reviewbox allows customers to upload and actively manage their own product catalog. We understand that your catalog changes over time as new listings are added and old ones are dropped. Managing your catalog with Reviewbox allows the flexibility to choose how many and which listings to monitor at any given time. You may only want to monitor a subset of your listings during certain times of the year.

Competitive product research is another important capability that Reviewbox enables. You may track competitive products or use Reviewbox to do new product research. When you are finished with your research, you can remove those listings from your active catalog.

What should my product catalog include?

To use Reviewbox to monitor your e-commerce listings, you’ll first need to assemble the information that Reviewbox uses to locate your products on Amazon and other retailers. An example product catalog is shown below.

source*

id*

Manufacturer Model Number (Custom Field)

Brand (Custom Field)

overstock

28681356-000

AT0093

MyBrand1

walmart

696207600

AT0093

MyBrand1

amazon

B07QN1QMQG

AT0093

MyBrand1

overstock

36027481-000

CT0052

MyBrand1

wayfair

W003135968

CT0052

MyBrand2

amazon

B07N8XDBMW

CT0052

MyBrand2

   *Note: source and id are required fields.

The source column specifies the retail site where each product listing appears and the id column is the specific identifier used by that retailer to identify your product. For Amazon.com, this id is the ASIN. The source and id are the only required information to begin using Reviewbox. If you wish to track and enforce Minimum Advertised Price (MAP) for your listings, you may also include columns for the min and max allowable price. For more about managing MAP prices, see Managing MAP prices.

What are custom fields and why should I use them?

You may be offering the same product across multiple retail sites. In this case, you might add a field to the catalog that specifies your identifier for the product (such as a manufacturer model number). You can use additional Custom Fields to help organize, filter, and generate reports about your product listings. Examples include the UPC, product category, brand, business unit, and other information.

How to assemble your catalog in a CSV file

Your product catalog must be submitted to Reviewbox in a comma-delimited text file, known as a CSV file. One easy way to generate a CSV file is to use Excel to lay out the information, then use the ‘Save As’ capability to save the CSV file.

The CSV file must contain 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. You can add any custom columns to the right of the two required columns. You may leave blank cells in the custom fields if necessary, but not in the source or id columns.

source – This field specifies the retail site where the product listing appears. The source values 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 in the Help Center.

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.

To the right of the source and id columns, you may also include min and max fields for the minimum and maximum acceptable MAP prices, and you may include your own custom fields, as described in the Custom Fields section.

An example catalog template is available here: bulk-listings-upload-template.csv.

2. How to upload your product catalog

To add listings to your catalog, Click on Catalog Management in the green left-hand menu. You will see the Add Listings button at the top left. The drop-down menu provides the option to Add Single Listing or Bulk Upload Listings.

add_listing_menu

Choose Bulk Upload Listings to add many product listings to Reviewbox at once. You will then see the screen below. Select one or more of the Reviewbox monitoring services where you want to add these listings. Click Next.

bulk_upload_window_1

On the next screen you will see instructions to upload a file containing the product listings to be added to your catalog. Drag your prepared catalog CSV file onto the upload screen and click Submit. See above for how to prepare the CSV file.

bulk_upload_window

If the listings went into your catalog, you will see a Success screen. Note that it may take up to 12 hours for Reviewbox to collect the initial data.

How to add a single listing to your catalog

Under Catalog Management, select Add Listings and choose Add Single Listing. You can add the listing to one or more of the Reviewbox monitoring services. Then click Next.

add_listing_window_1

The next screen allows you to manually enter the product listing information. Choose the appropriate retail website in the Source field. All supported retailers are listed there.

Note: Searchbox is currently available for Amazon retail sites only.

Next enter the Listing ID. For Amazon.com, this ID is the ASIN. For other retailers this ID should be the specific identifier used by that retailer. Often these are specific to the color, size, or other variation of the parent product. Finally, enter any Custom Field values for this product. When all fields are complete, click Submit.

add_listing_window_2

If the listing went into your catalog, you will see a Success screen. Note that it may take up to 12 hours for Reviewbox to collect the initial data.

3. View and verify your product catalog


Once your product catalog has been entered into the Reviewbox system, it can take up to 12 hours to retrieve data for your listings. The main Catalog Management page shows how many listings you have loaded in your catalog for each of the services you are subscribed to. Clicking on the name of a service will show you the number of listings by retailer.

The Total Listings Across Accounts section shows how many product listings are associated with your master license. For example, below, we have 100 listings loaded out of a possible 100 slots in our license.

The Active Listings For: section shows how many product listings are loaded in each sub-account that shares your master license. Many of our agency customers manage multiple sub-accounts for different brands. You can see all the sub-accounts in the dropdown next to Active Listings. In the example below, all of the 100 listings that are loaded are in the Alison account.

catalog_mgmt_screen

Once your data has been collected, you will see your product listings in the various services you are subscribed to. For example, to see the listings loaded into Reviewbox for review monitoring, use the left-hand green menu to navigate to Products and then Reviewbox. Select the Products tab at the top of the Reviewbox page and you will see your product listings along with a summary of all the ratings and reviews for each product.

rbox_products_tab_example

Download your current catalog

To download your product catalog, you must access it from the individual Reviewbox services. For example, if you want to see all the listings in Reviewbox, go to the Reviewbox Products page (shown above). Under Select Download, choose the Current View option. The Current View allows you to download the information that is currently displayed in the grid page into a CSV file. If you want to download your entire catalog, make sure that you clear all filters and view all custom fields before downloading the Current View.

4. How to delete listings from your catalog


If you want to remove listings from your catalog, simply go to Catalog Management and click on Delete Catalog. From there you will see options to Bulk Delete Listings or Delete Single Listing, as well as options for managing search terms.

delete_listings_menu

Manually delete a single listing

If you only have a few listings to remove, choose Delete Single Listing and the next screen will ask you which service(s) to remove the listing. Finally, you will be asked to enter the source and ID of the listing to be deleted.

Bulk delete listings

If you want to delete numerous listings from your catalog, choose Bulk Delete Listings. On the next screen, select the service(s) you want to remove the listings from. Click Next.

You can then upload a CSV file containing the listings to be removed from your catalog. The CSV file should be formatted in the same manner as a product upload file. It should contain just two columns: source and id. You do not need to include any custom fields.

bulk_delete_listings

Note: if you accidentally delete listings, please contact Reviewbox Support at support@getreviewbox.com within 48 hours to have them restored.

5. How to clear and replace your entire catalog

One common situation for our customers is to completely update or ‘refresh’ the entire product catalog several times a year. The best way to do this is:

  1. Download your current catalog – If you have the same set of listings in each of the services you are subscribed to (i.e. Reviewbox and Copybox), then you only need to download the catalog once. However, if you have different listings in the different services, you should download a separate file from each service. Save the CSV file(s) to your computer.
  2. Bulk delete your catalog – Use the current catalog files created in step 1 to bulk delete your listings from each service. This should completely clear your catalog.
  3. Upload your new catalog - Create a new CSV file with your updated listings and upload it to the relevant services.

6. How to update a subset of your listings

Sometimes you only need to update information about a few of your listings. In this case, you do not need to re-upload your entire catalog. You can simply create a CSV file that has the source, id, and custom field values for the listings that you want to change. Then go to Catalog Management and use Bulk Upload Listings to add them to your catalog. Any listings that were not included in this new CSV file will not be changed.

 

We're here to help. If you have additional questions, please contact support@getreviewbox.com.