Use supplier’s stock for product availability status on my front¶
Using ERP and drop shipping modules, it is possible to use supplier stock levels to set a product “in stock” on your website, here are the main steps :
- Create a new warehouse titled “suppliers” or a new warehouse per supplier
- In this/these warehouse(s), select “assignments” tab and check all checkboxes in the “sales” column.
Now, if a product has stock in this warehouse (and not in your warehouse), the product will be displayed “in stock” on your website.
Next, you have to populate stock levels in this new warehouse. To achieve this goal, 2 solutions :
- use ERP “Import product / warehouse stock levels” to manually upload csv file
- use Drop shipping “Import supplier stock file” feature to automatically import supplier stock levels.
Note : don’t forget to setup the “Target warehouse” in the supplier setting (tab FTP Account)
How to use Dropship Stock file import ?¶
Let’s take an example. We have 3 products that we want to be able to dropship :
We first need to create a new supplier (if not already done) and assign products to it.
Please refer to the Erp documentation for that part.
Don’t forget to set Dropship to Yes.
Now your supplier should look like this :
We are going to create a warehouse dedicated to all our suppliers (if not already done). Let’s name it “Suppliers WH” for our example.
Once done, we are ready to import supplier stock and price. Our supplier doesn’t have any FTP, so we need to make the csv file that will contains all the information.
Let’s consider they have 54 Sony for $29.99, 72 Nokia for $13.50 and 34 BackBerry for $29.99 .
The CSV file will look like this :
Save it in CSV format and let’s reopen it with notepad to see how it has been built :
We can notice that our field separator is a comma. We will need this information later. Don’t use a comma for decimals, but use a dot instead.
Now our file is ready.
Go to Erp > Purchase > Supplier > Select your supplier (here “MySupplier”) > Stock / Price import.
We are about to start the import. We have to configure the import like this :
If you don’t see the field delimiter, this is a known issue that can be fixed if you ask us a patch. We will definitely fix it in a next update.
We skip the first line as it is our header. the Sku is our 1st column, Qty our 2nd, and Price our 3rd. The sku mentioned are our sku, not the supplier ones, and the target warehouse is the supplier dedicated warehouse.
Save the configuration before to process the import.
Now, we just have to select the file and click on Process (Manually import file).
We are being redirected to Stock file import log, and we can see the status of the import :
Our products have been successfully imported ! Let’s have a look to the product screen :
The products are now also in the supplier’s warehouse. Let’s have a look to the product supplier tab :
The prices are correctly stored.
How can I exclude the dropshippable products from the ERP order preparation to avoid to ship some products twice ?¶
From Dropshiping 1.8.x, there is a “router” in dropshiping options.
This Dropshiping router can modify the ERP router behaviour for stock allocation : when a product matches the dropshiping “rules” from the Dropshiping configuration from here :
A special warehouse can be selected - the one you configure in the Router configuration.
The idea is to setupi ERP a new “fake” warehouse for Dropshipping, and in ERP, this warehouse has to be disabled for supply needs, disabled for sales a but not for order preparation.
Whena new order arrive, this warehouse can be choosen for reservation if a product matches teh router conditions. On this new warehouse, even if there si no stock, it is not a real problem, because you will dropship the products - the goal is only to exclude these product from orderprepration.
Then the reserved products will not appears in order preparation (they will appear but in grey), because they are reserved in a separate warehouse.
So, because of that, you can’t ship them twice.