Inventory Updater Tool for BigCommerce -

The Inventory Updater Tool is designed to streamline the process of updating inventory details for both primary products and their associated variants. Leveraging the simplicity of a CSV file filled with SKUs, it ensures a smooth integration of data. What sets this tool apart is its versatility, with its ability to support multiple functions, all of which are determined by the specific values within the fields of the CSV file.

Step 1: Create Your CSV FIle

The Inventory Updater Tool allows you to update product inventory settings by uploading a CSV file.

To begin, you will first need to create a CSV file with your product inventory data. Your CSV file can contain any of these supported fields:

SKU: This is a required field and can be either a parent or variant SKU.
stock: This is an optional field and should contain the in-stock value of the parent or variant you're updating.
- Numbers must be between 0 and 999999999.
- Negative numbers will produce an error.
low_stock: This is an optional field and should contain the low-stock value of the parent or variant you're updating.
- Numbers must be between 0 and 999999999.
- Negative numbers will produce an error.
tracking: This is an optional field which sets how inventory will be tracked on the item.
- If inventory is not currently set to be tracked on a product you can use this field with one of the following values to enable inventory tracking:
  - product = inventory is tracked on the product level
    - the value p can also be used
  - variant = inventory is tracked on the variant level
    - the value v can also be used
- If inventory is currently enabled on either the product or variant level and you want to disable inventory tracking, you can set this value to none.
visible: This is an optional field which sets whether the product is visible or not:
- yes = product is visible and searchable
  - the values of y, true, or 1 can also be used
- no = product is not visible or searchable
  - the values of n, false, or 0 can also be used
purchasability: This is an optional field which set whether the product is able to for purchased:
- available = the product is available for purchasing
  - the values of a, in stock, or in-stock can also be used
- disabled = the product is not available for purchasing
  - the values of d, out of stock, or out-of-stock can also be used
mininum_order_quantity: This is an optional field which sets the minimum purchase amount value for an item.
- Numbers must be between 0 and 999999999.
- Negative numbers will produce an error.
maximum: This is an optional field which sets the maximum purchase amount value for an item.
- Numbers must be between 0 and 999999999.
- Negative numbers will produce an error

Step 2: Launch Tool & Select File

To begin, launch the Inventory Updater Tool from the tile on the Your Store Tools dashboard.

Select your CSV file and click Next.

Step 3: Map Your Fields

Map the columns in your CSV file to the appropriate fields, then click Next.

Step 4: Select Your Notification Type and Submit

By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete. If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.

Once your selection is made, click Submit to finish.

Additional Tool Features

By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:

History - a list of the last 7 days of processing history for this tool.
Help - a link to this support document.

Additional Options for Premium Plan Subscribers

Scheduling a Tool to Run at a Later Day and Time

Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.

By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to schedule the tool to run at a specific date and time:

The scheduled start time is the time the tool will run, not complete.

Once you set the day and time for the tool to run, click Submit.

Scheduling a Tool to Run on a Recurring Schedule

Premium subscribers have access to schedule tools to run in advance. This option will be displayed after you set your notification type.

By default, the scheduling option is set to No. If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to run the tool on a recurring basis:

Options for recurring jobs include:

Schedule Start Date and Time: The day and time the first instance will run.
Repeat: The recurring schedule for this tool, which can be:
- Daily
- Weekly
- Monthly
Specify Hour: The hour of the day the tool will run.
- Times are based on the time zone set up in your Company Profile.
- Recurring runs can only be schedule at the top of the hour.
Ends: When the recurring job should stop. Options include:
- Never
- After a set number of runs have completed
- On a specific date and time

The scheduled start time is the time the tool will run, not complete.

Once your recurring options are set, click Submit.

Scheduling the Update Guest Order Tool to Automatically Check Historical Orders

In addition to the regular scheduling option available on all tools with the premium plan, the Update Guest Order tool allows store owners an additional scheduling option for checking historical orders on a regular, recurring basis.

This additional schedule, allows you to do the following:

Schedule a daily run to check and associate orders from the previous day.
Schedule a weekly run to check and associate orders from the previous day, week, two weeks, or three weeks.
Schedule a monthly run to check and associate orders from the previous day, week, two weeks, three weeks, month, two months, or three months.

In order to use this method for scheduling, you must set the schedule by going to the tool's tile in the Your Store Tools dashboard and select Create Schedule from the stacked menu:

From there you can schedule the tool to run on a daily, weekly, or monthly basis.

Did you find an error or need additional support? Contact us at support@yourstorewizards.com to let us know!