Follow

Setup and Inventory Feed (FTP)

Overview:

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

  1. Acenda 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 Acenda to process an Inventory Feed via (s)FTP

To update inventory/prices and automatically set items to offline or active in Acenda follow the steps below:

Prerequisite Steps (Outside Acenda)

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.

Note: Your file must contain all four columns; however, you can have blank values in the columns if you do not wish to update the field.

 Click here to download a sample Inventory Feed.

2. Create an FTP location for your files:  

You can purchase an FTP account/location at www.GoDaddy.com or other providers. Set the directory permissions be writable by Acenda so that the file name can be renamed after being processed.

Activate Shipping Feed Service in Acenda
1. From the Acenda dashboard click Services
2. Then click Services Library
The Services Library page displays.
3. Scroll down to Acenda Inventory Feed 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: Acenda will scan your ftp directory to locate the inventory feed by searching for files with the respective prefix in their filename, eg. INV. It will process the feed and rename the file with the suffix = .processed.  For example, INV-042017-1005.csv will be renamed INV-042017-1005.csv.processed after the inventory feed runs.
    • Set Offline Missing Variants: Checkbox if you want Acenda to set offline the products that at not contained in the inventory feed.
    • Email Template: After inventory processes, Acenda will generate an email that confirms the updates.

 Sample Twig template for the Email:

Processed {{numRows}} in {{filename}}
Total Set Offline: {{ totalSetOffline }}
Total Set Active: {{ totalSetActive }}

Negative SKUs:
{{ dump(negativeSkus) }}

SKUs Processed:
{{ dump(skus)}}

  • email to: Enter the email address(es) that you want to receive the inventory processed email. Separate multiple email addresses with commas.
  • 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 Acenda dashboard click Services
7. Then click My Services
The SERVICES page displays.
8. Locate the Inventory Feed in the list and click Edit
The Default Actions form displays.
9. Adjust the frequency that Acenda processes your Inventory Feed by clicking on the Generate Interval button
10. Click Save
 You can monitor your Inventory Feed service in Acenda dashboard > Events

 

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

0 Comments

Please sign in to leave a comment.
Powered by Zendesk