Skip to main content
Bulk Inventory Product Upload

Upload bulk product data via our CSV Inventory Upload Add-on

AmmoBot avatar
Written by AmmoBot
Updated over 2 months ago

The AmmoReady platform not only supports the creation of individual products but also offers the CSV Inventory Upload Add-on for bulk data uploads. This feature allows users to import multiple inventory items at once, streamlining the process compared to creating each product individually.

*Note: To successfully upload data via CSV, your file must include specific data points as outlined in this guide. If these requirements are not met exactly, the upload will fail. Please read this article carefully and follow the instructions closely to ensure a successful upload.

*Note: If you plan to use Distributor Catalog data for your products, it is advisable to wait until you have connected your Distributors, allowed their Catalogs to sync, and then proceed with uploading your CSV product data.

This guide is organized into several steps listed below. Please follow these steps in the given order:


Step 1: Install the CSV Inventory Upload Add-on

From your Dashboard, go to the Add-ons tab (https://app.ammoreadycloud.com/manage/addons).

Click Install on the CSV Inventory Upload add-on.


Step 2: Add Brands to your storefront

For the CSV import to function correctly, you need to ensure that the brands you plan to upload are available on your storefront or match the brand names exactly. To do this, cross-reference the product brands you intend to upload with the brands listed under the Brands tab in your Dashboard.

Please reference the Brands Tab article on how to access the available brands and how to search for specific brands.


Step 3: Download our CSV template(s)

After installing the CSV Inventory Upload Add-on, download one of the two available CSV templates to transfer your inventory data. The choice of template will depend on your specific use case.

Inventory template types:

'match-or-create' (most typical): Download and use the 'match-or-create' template if this is your first inventory upload with initial quantity data, or if you're adding new products to your existing inventory.

'match-only' (less typical): Download and use the 'match-only' template if you already have inventory present and simply want to update quantity data/customer pricing.

To download a template, navigate to the Inventory tab.

Next, click New Import.

On the Batch Imports / New page, select which file to download.


Step 4: Prepare your inventory data

Now that you have our CSV template, the next step is to transfer your product data into it. It is crucial to follow the instructions provided in this step precisely to ensure that your CSV data imports correctly.

'match-or-create' Data Mode

When using 'match-or-create' mode, the following data points in the CSV template must be populated with the required information:

  • Product model name [name] (ex. LC9s)

  • UPC or SKU (ex. 736676032648)

  • Brand name [brand] (ex. Ruger)

  • Sub-category [subcategory] (ex. Semi-Automatic) -- See here for required Sub-category information

  • Quantity on hand (ex. 10)

  • Customer Price [customer_price] (ex. 349.99)

  • Product Type [product_type] (must be one of the following: handgun, long_gun, ammunition, suppressor, merchandise)

We recommend using our CSV template and replacing the sample data with your own product information, ensuring it matches the specified data points.

*Note: DO NOT remove/add/edit any of the header columns in the CSV template file.

These headers must remain unchanged for our system to process the file correctly. Simply insert your specific product data under each corresponding header.

*Note: Make sure to remove/replace any placeholder data (e.g., <Collection ID>) that is in the template to prevent any errors when uploading.

'match-only' Data Mode

When using 'match-only' mode, the data requirements are much less restrictive. Only upc/sku, quantity, and customer_price are required for a successful upload.

New products will not be created when using this mode.

A note on image links

For image URLs to display correctly, they must end with an image file format extension (e.g., .jpg, .png) rather than just linking to a web page.

Correct: https://www.exampleimagewebsite.com/really-cool-image.jpg

Incorrect: https://www.exampleimagewebsite.com/really-cool-image

A note on collections

If you’ve created custom Collections, you can assign specific inventory items to them by entering the Collection ID numbers during the CSV upload. You can find these Collection IDs in the Collections tab.(https://app.ammoreadycloud.com/manage/collections).

Simply enter this ID number under the collections column header to place the inventory item into the corresponding Collection.


Step 5: Upload your CSV file

Once you have transferred your product data and correctly formatted the CSV file, you’re ready to upload it.

Navigate back to the Inventory tab and select New Import.

On the Batch Imports / New page, select your preferred Mode from the dropdown menu (most likely 'match-or-create') and then click Choose File to select your CSV file upload.

Finally, click Upload.

Once the upload is complete, you should receive an email notification telling you so.


Step 6: Error handling

If there is an upload error or if some inventory items from your CSV file do not appear, you will need to check the error log.

Navigate back to the Inventory tab and click New Import. On this page, click Batch Imports.

On the next page you will be able to view the CSV file(s) you've uploaded, along with their correspond status and timestamp. Simply click on the CSV file name to navigate to the error page.

The error page will display which line number from your CSV file contains the error, along with the actual error printed out.

If any of the errors are unclear to you, please contact our support team via the in-app chat to help troubleshoot any issues.

Did this answer your question?