How to use supplier’s stock to calculate products availability statuses on my front¶
If you are using ERP and Drop shipping modules together, you are able to use suppliers stock levels to determine when a product will become “in stock” or “out of stock” on your website.
To do it, please follow these few steps :
- Create a new warehouse called “Suppliers”, or a new warehouse per supplier if you got suppliers having common products.
- In this/these new warehouse(s), “assignments” tab, check the “sales” assignment for all websites (including “Admin” one).
From now, if a product is in stock in this warehouse (even if it’s not in your other warehouses), it will be displayed as “in stock” on your website.
Next, you will need to populate products stock levels in this new warehouse. You can do it by 2 ways :
- Using ERP import in :
System > Import/Export > Dataflow - Advanced Profiles, then select “Import product / warehouse stock levels” to manually upload a CSV file.
- Using Drop shipping “Import supplier stock” features, to automatically or manually import supplier stock levels.
More informations on Suppliers stock features : Drop Shipping - Stock Price import
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.
How can I modify teh hour of the import schedule¶
All active supplier import are triggered around 11AM everyday
if you want to modify it you need to edit the file
around line 230 modify the line
<cron_expr>05 11 * * *</cron_expr>
following crontab logic : https://en.wikipedia.org/wiki/Cron#Overview
Then refresh the magento config cache section.