Setup an Inventory Feed (FTP)

Overview:

There are four ways to keep your inventory in sync with your store:

  1. Your webstore automatically adjusts inventory as items are sold (-) and returned (+) online

  2. Use the Acenda API's to update inventory

  3. Upload an Inventory Feed manually

  4. 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

  1. 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.

  2. Create an FTP location for your files: Your account representative will provide an FTP account/location. After receiving your credentials, please do the following:

    1. Download Filezilla (or any service you prefer)

    2. Enter your credentials as instructed by your account representative

    3. After logging in, drag and drop the formatted spreadsheet into the /inventory folder and our system will update accordingly

    Activate Shipping Feed Service

    1. From the dashboard click Services.

    2. Then click Services Library.

      The Services Library page displays.

    3. Scroll down to Inventory Feed 2.0 and click Add Service.

      The Service page displays.

    4. 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.

    5. Click Save.

    6. From the dashboard click Services.

    7. Then click My Services.

      The Services page displays.

      +Enlarge Graphic

    8. Locate the Inventory Feed in the list and click Edit.

      The Default Actions form displays.

    9. Adjust the frequency that your store processes your Inventory Feed by clicking on the Generate button within the inventory_ingest_files service function.

    10. Adjust the frequency that the service pushes the records into your webstore by clicking on the Generate button within the inventory_push service function.

    11. 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.

    12. Click Save.

    You can monitor your Inventory Feed service in Dashboard > Events.

Attachments

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

There are 0 Comments

Please sign in to leave a comment.