Menu Close

Get Support From ShopWired Close

All systems operational

Subscribe To Updates
Prefer To Live Chat? Chat directly with ShopWired support Available 9.30am to 5.30pm Monday to Friday (extended hours coming soon) Quickest response time
Send A Message
Response within 24 hours

Menu Close

Menu

Automatic stock sync

If stock levels for your products are controlled or available on an external source (e.g. a file hosted externally) you can use the Stock Sync app to automatically sync the stock levels for your products from the external source, without you needing to do anything.

You can also use this app to perform 'one off' stock syncs by uploading a CSV file and confirming which headings correspond to the SKU and Quantity. This app can be useful therefore if you cannot use the normal stock import system that we offer.

Once you've installed the app you'll be able to access the configuration page through the menu (select 'apps and extensions' and then 'stock sync').

Setting up an external HTTP source
Setting up an external FTP source
Uploading a stock file
Processing time

File type

The system only works with CSV (comma separated values) files and not with Excel spreadsheets or database files.


Setting up an external HTTP source

If you're configuring an automatic sync from a file that is available at a URL select 'add a new HTTP source'.

Enter the URL where the file is located in the Stock File URL field.

The external source spreadsheet should have two column headings (it can contain other data), one for the SKU code and one for the stock quantity.

Enter the column heading text on the file that relates to the SKU code into the SKU Heading field.

Enter the column heading text on the file that relates to the stock quantity into the Quantity Heading field.

We recommend configuring the app so that SKU codes with the same stock level are skipped (and not updated) by ticking the Skip SKUs With The Same Stock tick box.

Finally, to enable the app make sure the Enable The Download/Update tick box is ticked.

You should now have something that looks like the example below.

Once you've finished, click the 'add this source' button.

The app will start running immediately.


Setting up an external FTP source

If you're configuring an automatic sync from a file that is available on a server that can be connected to via FTP select 'add a new FTP source'.

Enter the server into the Host Name field.

Enter the port number (of the server) into the Port field. (The default for FTP is 21)

Next, enter the Username and Password that is used to connect to the server.

In the Path To CSV File field you should enter the full path to the file on the server, including the file name and file extension (which must be CSV).

The external source spreadsheet should have two column headings (it can contain other data), one for the SKU code and one for the stock quantity.

Enter the column heading text on the file that relates to the SKU code into the SKU Heading field.

Enter the column heading text on the file that relates to the stock quantity into the Quantity Heading field.

We recommend configuring the app so that SKU codes with the same stock level are skipped (and not updated) by ticking the Skip SKUs With The Same Stock tick box.

If you would like the app to delete the file once it has been downloaded tick the File Deletion tick box.

Finally, to enable the app make sure the Enable The Download/Update tick box is ticked.

You should now have something that looks like the example below.

Once you've finished, click the 'add this source' button.

The app will start running immediately.


Uploading a file

If you're uploading a CSV file of your stock quantities, select 'upload a stock file'.

The external source spreadsheet should have two column headings (it can contain other data), one for the SKU code and one for the stock quantity.

Enter the column heading text on the file that relates to the SKU code into the SKU Heading field.

Enter the column heading text on the file that relates to the stock quantity into the Quantity Heading field.

Select the file containing the stock levels from your computer's hard drive and click the 'upload file and update stock' button.


Processing time

The automatic system will download the stock file every 60 minutes.

The system will not process a new file if it is already processing an existing file. Therefore if your file contains a lot of SKU codes (i.e. over 5,000) the system may not be able to process a file every 60 minutes and the update times might be longer.