Skip to main content
Bulk updates - price and availability

Learn how to bulk update the price and availability of your inventory.

Elie avatar
Written by Elie
Updated over a week ago

Keeping the availability and prices of your products up to date is essential for your customers to have the best shopping experience at your store. There are two options to ensure these are always up to date, depending on the number of products involved.

If you need to update the price and availability of a few products (our recommendation is less than 5), you can easily do it individually by following the steps in the "Updating your product" article. If there are more than 5, we recommend you update their prices and availability in bulk by following the steps below:

1. Download the basic template

  1. Select the "Products" tab and access the "Inventory" option, then proceed to the "Export" option.

  2. Upon pressing the ‘Export’ button, you will be able to "export" or "download" your current inventory. This is where you can make edits to update the products.

  3. You’ll need to select the store branches you want manually, and you can set the availability and price by product for each one.

When you press "Export" in each case, your inventory file will be created. Sometimes this process may take some time, but once it's available for download, you can access it.

Your file will have this structure:

Product ID

Name

SKU

Availability - Branch name 1

Availability - Branch name 2

Unit Price

Weight Price

Package Price

With the information in the "Product ID", "Name", and "SKU" columns, you can identify each of the products to update, and in the following columns, you can set the price and availability of each of them in each branch, or in all of them.

Remember:

  • Product ID corresponds to the internal code of your product within TrakiTrak.

  • Name corresponds to the product name.

  • SKU corresponds to the number with which you identify this product in your store. It is unique among your products.

2. Update the template

To update the price and availability of your products, you can reference the Product ID, Name, and SKU fields. It’s best not to edit the information or headers in these fields. You can edit price and availability fields in specific branches or in all of them.

To determine the price of a product, all you have to do is write it down. Include the required format using periods and commas. You should not include currency signs ($, USD, s/, etc.). In the following table, you can see examples of how prices should be entered:

Country

Price to enter

Price to show

Lebanon

55000

L.B.P 55.000

UAE

367.30

AED 367.30

USA

12104,98

US$12.104,98

Canada

1334,97

CAD 1.334,97

To determine the availability of a product, you can choose from the following options that will be displayed in the template. You only have to select one of them.

  • Not available: this option should be used when a product is not available and will not be available again soon. By marking a product as not available, customers won’t be able to view it on TrakiTrak.

  • Available: this option should be used when a product is available and in stock. Customers will be able to view this product on TrakiTrak and can add it to their shopping carts.

  • Temporarily out of stock: this option should be used when a product is currently unavailable, but will be back in stock soon. Customers will be able to see the product on TrakiTrak, but will not be able to add it to their carts. This availability should be temporary, so that it does not become frustrating for customers to find products they are interested in in this state on a regular basis.

  • Out of season: this option should be used for products that are out of season. For example: holiday decorations when it’s not the holiday season.

3. File upload: bulk update

  1. When you’re finished updating the price and availability of the products, go back to the ‘inventory’ tab, tap the ‘Inventory’ section and select the ‘Bulk update’ button.


  2. From there, a window will appear in which you can load a document using the ‘Select a file’ button. Press it and load the document you filled in.

  3. If the document was filled out correctly, you will see a window with a summary of the products you are updating. If everything looks good, press ‘Continue’.



    💡 If something was entered incorrectly, a window will show this, and you will be able to download the document again with a callout of the cells where the mistake was made, and you can try again.


  4. You will see a message confirming that your bulk upload is being processed. You can close the window and continue working normally in the Store Center.

  5. When the update is ready, you will see a message at the bottom of the screen confirming the success of the update.

    💡 If certain products could not be updated, you can tap the message button, and you’ll be able to see a file detailing which ones could not be updated, so that you can try again.

If you run into any issues, remember you can always contact Store Support through the chat in the Store Center or via email at stores@trakitrak.com

Did this answer your question?