Welcome to our Help Center

How to Bulk Upload Products

How to Bulk Upload Custom Product Info

If you want to add multiple products to your site at once and feel comfortable working in Excel, this option may be for you! Simply download the Excel template and input your product data, then use the Bulk Products Loader to upload them.

 

Making your spreadsheet:

  1. Download the bulk products Excel template by clicking here, then open it using Microsoft Excel.
  2. In the spreadsheet, delete the columns you don't want to update, then enter the information for the parts you do want to update into the corresponding columns.
  3. Weight is measured in pounds (lbs.) and all dimensions are measured in inches (in.). Also, enter either TRUE or FALSE if marking a part:
    • Discontinued
    • Not for sale
    • Hazmat
    • Own Box
    • Call for Availability
    • Featured Product 

 

Categories Column:

Note: before you can upload products, you'll need to have created a category for them first.

If you have a part that's only going to be in a single category, simply enter the Category Key for that category into the Categories column of the product.  If you want to add a product with multiple categories, use two "pipes" ("||" the vertical line found above the "Enter" key on your keyboard) to separate multiple categories.

Examples:

Part in a single category: toyota-accessories

Part in two categories: toyota-accessories||apparel-and-lifestyle

Part in three categories: toyota-accessories||apparel-and-lifestyle||clothing

Separating categories like this will place the product in each of the categories listed. It is not necessary to list multiple categories if your product is to be nested within a subcategory. For example, a product in the "clothing" category (above) does not necessarily need to also be in the "apparel-and-lifestyle" category that contains it. If you wanted to make the product visible only in the clothing category, you'd just enter that category key into the spreadsheet. Since each category key is unique, you don't need to list the top-level category to make a product appear in a subcategory.

 

How to upload your spreadsheet:

  1. ***Important: Make sure to save your Excel file as a .CSV
     
  2. If you haven't already, log in to your RevolutionParts Control Panel.
  3. In the search box on the top-left of the page, type "Bulk Product Loader" and click the highlighted section (or hit enter on your keyboard).
  4. Select a default category (this will apply to parts in your spreadsheet that don't have data in the categories column, but will be ignored if your parts have a category defined).
  5. Choose your upload rule (which determines how to handle data in your sheet and data already in your custom catalog).
  6. Select your .CSV (comma delimited file) with all of your products.
  7. Click the "Upload file" button.
  8. Next, you'll map your columns to the correct data (useful in case you rename the columns or want to bulk upload other data such as Meta Titles and Descriptions). Selecting "Skip" will ignore the data in that column. For example, if we had dimensional information we would want to select from the drop down menu and map it to the appropriate data field.
     
  9. Finally, click "Update Products" and you're all done! Your upload should begin immediately, and while it may take a few minutes to fully add the products, you should be able to see them in your "Browse Products" view.

 

PLEASE NOTE that products uploaded today will be visible in your website's search tool tomorrow. The search tool indexes overnight, meaning anything you add won't be searchable until the following day.

 

Final Thoughts

If you plan on uploading products in bulk, it may be easier to do the same with images. To do this, you'll need to contact RevolutionParts Support to get your Store ID, then visit this article: How to Bulk Upload Images.

Once your products are added, you can send an email to our support team so we can find the best place to incorporate them into your website's design. Common implementations include a link to the category in the top menu, or individual products featured directly on the homepage. If you want to look at the products before then, click on the "Site Map" link found at the footer of your website. There, you'll find your categories with links to your products.


EVERYTHING BELOW THIS BLOCK IS MANAGE-ONLY CONTENT.

This text will not appear on the finished article.

 

How to Bulk Upload OEM & Custom Products Info

Updating OEM Part Info is very easy. Here are some of the things you can update:

  • Part Number
  • Description
  • Weight
  • Length
  • Width
  • Height
  • Discontinued
  • Controlled/Hazmat
  • Call for availability
  • Not for Sale
  • Free Shipping

In order to correctly use the Bulk Loader, you'll need to download the template spreadsheet.  The template contains all fields available for you to update using the Bulk Loader.

PLEASE NOTE: When you open the file, first delete the columns you don't want to update. For the Bulk Loader and OEM Part Info, weight is measured in pounds (lbs.) and all dimensions are measured in inches (in.). Also, enter TRUE or FALSE if marking part:

  • Discontinued
  • Not for sale
  • Hazmat
  • Own Box
  • Call for Availability
  • Featured Product
  1. Click on the arrow to the right of you name on the top-right corner and select "Account Settings."Screen_Shot_2017-07-06_at_1.21.46_PM.png
  2. In the menu on the left, select Bulk, then Imports 
    Screen_Shot_2017-07-06_at_1.27.10_PM.png
  3. Click the New Import button (a box will pop up) 
    Screen_Shot_2017-07-06_at_1.30.41_PM.png
  4. Select Products from the dropdown 
    Screen_Shot_2017-07-06_at_1.32.55_PM.png
  5. From here, you can download the template (if you haven't already). When your file is ready for upload, click on the "Select File (.csv)" button and select your csv file.

 

That's it! Your file should load into the system, which will kick off the process of adding them to your store. It may take a few minutes for your products to be added, after which they'll be available for purchase.

PLEASE NOTE that products uploaded today will be visible in your website's search tool tomorrow. The search tool indexes overnight, meaning anything you add won't be searchable until the following day.


If you have any questions, feel free to reach out to us by emailing
support@revolutionparts.com or calling 480-779-7278!

RevolutionParts Logo
Powered by Zendesk