How to Upload Inventory

Uploading inventory is one way to add transparency on when a part is estimated to ship based on your preferences. Inventory uploads will only affect parts that are tied to the genuine RevolutionParts parts OEM catalog (aftermarket or custom part numbers are not supported at this time). 

Getting Started

You'll need to create a separate .csv file in Microsoft Excel for each and every make for which you want to upload inventory, meaning you'll need a file for Ford, a file for Mopar, a file for Honda, etc. The first row of your .csv file should contain the following:

PART_NUMBER, QTY

You can download an example file by clicking here.

NOTE: Even if you have a bin but are out of a part, please include it in the .csv file with "0" for the quantity.  You can exclude items that you do not stock.

With the above values as your column names, put your part numbers in the first column, the quantity you have of each in the second column.

 

Filename

Your file will need to be saved as a comma separated value (.csv). The name of the file must be exactly as follows: the word, "inventory," followed by a hyphen, then your file's "file ID," then the .csv file extension. See below for an example:

Format: inventory-FILEID.csv

Example: inventory-54545445545SDGSDDGGYH54555.csv

PLEASE NOTE: You will need to have a separate file ID for each individual file. Contact RevolutionParts Support for a file ID for each list you plan to upload.

 

Configuration

In order to complete the initial setup process, you will need to contact RevolutionParts Support. Send an email to [email protected] explaining that you'd like to set up manual inventory upload, and that you would like it enabled on your site. The current messaging for inventory notifications displays as follows:

  • In-Stock before daily cutoff time
  • In-Stock after daily cutoff time
  • In-Stock on the weekend
  • Special order/Out-of-Stock items

The current messaging for these timeframes are below:

  • Orders placed within the next ((hours,minutes)) will ship today!
  • Orders placed today will ship tomorrow!
  • Orders placed today will ship on Monday!
  • Will ship in 2-4 business days

Contact RevolutionParts Support if you want to modify you inventory messaging.

NOTE: We will never display the actual inventory numbers for a part. The inventory messages/shipping estimates are designed to add transparency to customers on the estimated ship date, not to reflect or show actual stock values.

 

Upload Info

We use an FTP server to host the .csv file you'll be uploading. To upload your file, navigate to the following address in File Explorer for Windows (not Internet Explorer): ftp://[email protected]/Uploads

For Mac users, you will need to use an FTP client to upload your inventory (via an FTP client, such as Cyberduck).

Once you drop your file into the FTP server, your inventory upload will be processed automatically. You can verify this by looking for your configured inventory messages on a part referenced in your latest upload, but it may take a few minutes for your file to process. Contact RevolutionParts Support if you don't see changes within 30 minutes of uploading your file.

While manual inventory upload is useful, it's also manual. You'll have to upload an updated .csv file every time you plan to update your inventory levels, whether it be when you receive new stock of previously Out-of-Stock items, or when you run out of stock of currently In-Stock items. Keeping up with your inventory is not necessary, but strongly recommended (so that you can be transparent with your buyers).


EVERYTHING BELOW THIS BLOCK IS MANAGE-ONLY CONTENT.

This text will not appear on the finished article.

 

 

Uploading Inventory Manually

To manually upload inventory files for your warehouse(s),

  1. Click on Products in the top-menu. 
    1.png
  2. Select Inventory from the left-side menu, then Uploads.
    Screen_Shot_2018-06-21_at_4.14.05_PM.png
  3. Click the green "+Upload Inventory File" button in the top-right corner.
    Screen_Shot_2018-06-21_at_4.18.01_PM.png
  4. Feed requirements (IMPORTANT)
    • Download the CSV Template provided at the bottom of the popup. You can also download the template at the bottom of this article.
      Screen_Shot_2018-06-21_at_4.23.14_PM.png
    • Open the template in Microsoft Excel, then fill the template with your inventory information. You must save the file as a .csv before it will work with the system.
    • Your file must only contain part number in column A, quantity in column B, and nothing else.
      6.png

  5. Once you've saved your .csv inventory file, click "Select File," then choose it.
    Screen_Shot_2018-06-21_at_4.20.46_PM.png
  6. Next, set the warehouse and manufacturer associated with the inventory file.
    Screen_Shot_2018-06-21_at_4.19.14_PM.png
  7. Once everything is configured, click the "Upload" button to load the file into the system.
    Screen_Shot_2018-06-21_at_4.21.44_PM.png

 

Uploading Inventory Files via FTP

You can upload your inventory to the system by dropping it right into our FTP server! Configuration is super simple, and our system provides you with the necessary filename and FTP server URL. Simply use the FTP client of your choice to upload your files, and if they're named as designated by the Control Panel, they'll automatically apply your inventory. To configure the FTP upload method,

  1. Click on Products in the top-menu.1.png
  2. Select Inventory from the left-side menu, then Configuration.
    Screen_Shot_2018-06-21_at_4.14.05_PM_2.png
  3. After that, click the green "+Inventory Feed" button on the top-right corner.
    Screen_Shot_2018-06-21_at_4.28.56_PM.png
  4. Click the "FTP" button, then Continue.
    Screen_Shot_2018-06-21_at_4.31.43_PM.png
  5. Select the warehouse and manufacturer associated with your file.
    Screen_Shot_2018-06-21_at_4.32.52_PM.png
    • Although you may not have an inventory file yet, you'll need to set up and save the configuration before any FTP uploads will work.
  6. IMPORTANT: the name of your inventory file is how our server will identify your files. The required filename is given to you in the popup. You must name your .csv inventory file to match this filename exactly, otherwise your uploads won't work. Your filename consists of the word "inventory," a dash, your unique file ID, and a .csv file extension. See an example below:
    Screen_Shot_2018-06-21_at_4.34.49_PM.png
  7. You can use any FTP client to connect to our server at the address provided in the popup. For copy/paste reasons, the FTP server address URL is:
    ftp://[email protected]/Uploads
  8. Click the "Create Inventory Feed" button to save your configuration.
    Screen_Shot_2018-06-21_at_4.38.51_PM.png

Once the FTP feed is configured, you can access our server at the address above and drop/upload your inventory file (matching the name provided in the popup). Using this method, you won't have to log into the Control Panel to manually upload inventory.

 

Frequently Asked Questions about Inventory Uploads

  1. How long does it take for my inventory to upload?
    • Inventory files will take time depending on the size of the file. Most will take a few minutes but large files can take up to a few hours to upload inventory.
  2. What happens when I upload a new inventory file?
    • New inventory files will completely replace existing inventory information. If your inventory file differs to much from the previous file you will not be able to upload inventory. Please contact [email protected] and we will help push your upload through.
  3. How many products can I upload in my inventory file?
    • Inventory files are limited to a maximum of 15,000 rows.

If you have any questions, feel free to reach out to us by emailing
[email protected] or calling 480-779-7278!

RevolutionParts Logo