4. Supplier Stock Import

This feature allows to import supplier stock from a remote supplier csv file hosted on a FTP server.

Overview

First go in supplier view, you will see two new tabs :

  • Stock Import Settings
  • Stock Import History

The first one allows to configure FTP credentials and to set column indexes :

  • Host : FTP host from which download the report
  • Port : FTP port to use for connection
  • Login : FTP login
  • Password : FTP password
  • File path : remote file path on FTP server (from user directory)
  • Passive Mode : allows to enable / disable FTP passive mode
  • Separator : character used as column separator (ex : ,)
  • Enclosure : character used as data enclosure (ex : ”)
  • Target Warehouse : warehouse to use for inventory update
  • Sku index : your product sku position in csv file’s rows (ex : 0 for the first column)
  • Supplier Sku index : supplier sku position in csv file’s rows
  • Qty index : qty position in csv file’s rows
  • Buying Price index : supplier price in csv file’s rows
  • Import now button : will launch an import

Note

you must set at least index for Sku OR Supplier Sku

Be careful index start from 0.

The second tab displays stock import history and allows to download report for each one.

Process

  1. the extension will try to connect to FTP server, if it can not, the report will be flagged as “in” error with the error message and the process stops.
  2. the file will be parsed according to File settings, if sku and supplier sku indexes are set, the extension tries to retrieve product from sku, if it can not be found then it will try to retrieve product from supplier product association. If product can not be found, the line will be flagged with status product_not_found.
  3. the extension will try to update supplier buying price and supplier stock if indexes are set. Price with a value < 0 will not be updated.

Note

if supplier product association isn’t already set, it will be automatically created during the import process.

Run

There are two ways for run supplier stock import :

  • From supplier view by using “Import Now” button
  • From command line by using the following command : php ./bin/magento bms_dropshipping:supplier_stock_import --supplierId {{supplier_id}}

Note

no cron is added, in order to schedule this task, you must add the previous command in your crontab