Stock & price sync app
You can sync stock levels or prices for your products and product variations from an external source (i.e. a file hosted externally) using the Stock & price sync app.
The app can be used to gather stock quantities or price updates automatically (syncing data roughly every hour) or you can upload a CSV file manually to perform a one-off sync.
To install the stock sync app:
- Navigate to Apps
- Locate the Stock & price sync app
- Select
install this app
Once you've installed the app, navigate to Apps > Manage > Stock sync from your ShopWired account to configure the sync settings.
Once you have installed the app you can configure the sync:
- For either stock updates, price updates or both
- Sync from a CSV file hosted on a server (the app connects to your server via FTP or SFTP)
- Sync from a CSV file available at a publicly accessible URL
- Sync from a CSV file that you upload directly to the app
The app downloads a new file from a configured source approximately every 60 minutes and processes it. depends on how many SKU codes and changes are contained within the source file.
Configuring an SFTP/FTP source
Configuring an SFTP/FTP source
The app can download and sync stock and prices from a CSV file hosted on a server that can be connected to via FTP.
To configure an SFTP/FTP source:
- Select either
add a new FTP sourceoradd a new SFTP source - Configure the connection information for your server (Host, Port, Username and Password) - these will be provided by your server provider
- Enter the to the CSV file
- Enter the headings for the columns in the CSV file that contain the SKU codes, quantities and prices (if just syncing quantities or prices you can leave one of these settings blank)
- Select the
test sourceoption to ensure the connection information is correct, that the app can successfully connect to your server, access the file and that your configured column headings match - To configure the app to remove the file once it has downloaded it, enable the
file deletionsetting - Select the
enable the download/updatesetting and clickadd this source
The app will start running immediately but the initial sync may take up to 2 hours to complete.
Configuring an HTTP source
Configuring an HTTP source
The app can download and sync stock and prices from a CSV file located on a publicly accessible URL.
To configure an HTTP source:
- Select
add a new HTTP source - Enter the URL of the CSV file into the Stock file URL setting
- Enter the headings for the columns in the CSV file that contain the SKU codes, quantities and prices (if just syncing quantities or prices you can leave one of these settings blank)
- Select the
test sourceoption to ensure the app can access the file and that your configured column headings match - Select the
enable the download/updatesetting and clickadd this source
The app will start running immediately but the initial sync may take up to 2 hours to complete.
Uploading a file
Uploading a file
To upload a CSV file of your stock quantities and prices manually:
- Locate the
upload a stock filesection - Use the settings SKU heading, Quantity heading and Price heading to enter the headings for the column names in your CSV file
- If you're only syncing quantities or prices you can leave the other setting blank
- Select the CSV file from your device
- Select
upload file and update stock
The sync will begin as soon as you upload the file but will take some time to process the file depending on the quantity of SKUs contained.
App data removal
App data removal
To reduce the number of the app stores a cached value for each SKU's price and stock quantity.
- Cached values expire 24 hours after creation
- If a SKU's stock or price is changed directly in ShopWired but matches the cached value from the external file, the app won’t update it until the cache expires
- Uploading a CSV file in the Upload a stock file section ignores the cache for SKUs in the file
- You can remove all cached values manually by selecting
remove stored app datain the App data removal section - This option can only be used once every 24 hours
