Setup an Inventory Feed (FTP)
Overview:
There are four ways to keep your inventory in sync with your store:
-
Your webstore automatically adjusts inventory as items are sold (-) and returned (+) online
-
Use the Acenda API's to update inventory
-
Upload an Inventory Feed manually
-
Configure your webstore to process an Inventory Feed via (s)FTP
To update inventory/prices and automatically set items to offline or active, follow the steps below:
Prerequisite Steps
-
Create a comma-delimited file (CSV) with the following required columns:
-
variant.sku, variant.barcode, OR variant.id: Select either SKU, Barcode, ID (variant) for your column header
-
variant.price: The selling price for the variant, eg. 99.99 (do not include the $ sign)
-
variant.compare_price: The compare price for the variant, eg. 199.99 (do not include the $ sign)
-
variant.inventory_quantity: The quantity on hand for the variant, eg. 9999
Click here to download a sample Inventory Feed.
-
-
Create an FTP location for your files: Your account representative will provide an FTP account/location. After receiving your credentials, please do the following:
-
Download Filezilla (or any service you prefer)
-
Enter your credentials as instructed by your account representative
-
After logging in, drag and drop the formatted spreadsheet into the /inventory folder and our system will update accordingly
Activate Shipping Feed Service
-
From the dashboard click Services.
-
Then click Services Library.
The Services Library page displays.
-
Scroll down to Inventory Feed 2.0 and click Add Service.
The Service page displays.
-
Enter the Service details:
-
Status: Turn the feed on/off
-
Title: A friendly title for the inventory service, eg. Store Inventory Feed.
-
Remote file Path: the FTP or sFTP path for your file e.g. ftp://ftp.sitename.com
-
Note: You must include ftp:// OR sftp://
-
Login Username: The username for your ftp account
-
Login Password: The password for your ftp account
-
File Prefix: Your store will scan your ftp directory to locate the inventory feed by searching for files with the respective prefix in their filename, eg. YOURSTORENAME-INV. It will process the feed and rename the file with the suffix = .processed. For example, YOURSTORENAMEINV-INV-042017-1005.csv will be renamed YOURSTORENAMEINV-042017-1005.csv.processed after the inventory feed runs.
-
Set Offline Missing Variants: Checkbox if you want to set offline the products that at not contained in the inventory feed.
-
Key Type: Select the field you are using for column 1 in your feed, either SKU for variant.sku or BARCODE for variant.barcode.
-
-
Click Save.
-
From the dashboard click Services.
-
Then click My Services.
The Services page displays.
-
Locate the Inventory Feed in the list and click Edit.
The Default Actions form displays.
-
Adjust the frequency that your store processes your Inventory Feed by clicking on the Generate button within the inventory_ingest_files service function.
-
Adjust the frequency that the service pushes the records into your webstore by clicking on the Generate button within the inventory_push service function.
-
Adjust the frequency that the service clears old records out of the database by clicking on the Generate button within the feed_maintenance service function.
-
Click Save.
You can monitor your Inventory Feed service in Dashboard > Events.
-
Please sign in to leave a comment.
There are 0 Comments