3. Configuration

Drop Shipping

To configure the extension, select menu System > Configuration, and then ERP > Drop Shipping.

Version

In this panel, you can see what’s your actual version of Drop Shipping.

_images/Version.png

Note

To check if your version is up to date, go to System > Config, and then My BMS > My Extensions

Tabs to display

In this panel, you can choose which tabs will be displayed in the Drop Shipping main screen (ERP > Purchasing > Drop Shipping).

_images/8a18657365bc47c5c814ffda3b573fdf.png
Field Value
Display pending supplier response Orders which are waiting for the supplier response about possibility or not to drop ship the products
Display pending price response Orders which are waiting for a price request to the supplier
Display Shipping Confirmation Orders which are waiting for a supplier shipping confirmation
Display drop shipped history History of all successful drop ships

Available actions for Drop Shippable tab

In this panel, you can choose available actions for orders displayed in the “Drop Shippable” tab.

_images/0f4c81c81feab47e7925fa85322eff78.png
Field Value
Create purchase order Create a purchase order containing all ordered items
Price request Send an email to suppliers associated with ordered items, to ask them for items prices
Drop ship Ask the supplier to do a drop ship
Drop ship request Send a drop ship request email to the supplier, containing ordered items list. Once the request has been validated by the supplier, you can process to the drop ship

Price response confirmation

In this panel, you can choose the next action to do after price’s confirmation, in the case where supplier price request is activated.

_images/c91a5c5532b420d3d0f2ccecb02f17ad.png

Action : Select the next action to do after price’s confirmation, between these 2 :

Field Value
Drop ship request Send a drop ship request to the supplier to manage the shipment
Drop ship Ask the supplier to do the drop ship without waiting any confirmation from him

Drop shippable orders

An order is selected as drop shippable if it’s considered by ERP and if order’s products have at least one association with a supplier.

In this panel, you can add several filters for the selection of drop shippable orders.

_images/88a8b185d2eaa3279c191fa591e4375a.png
Field Value
Allow drop ship only for these order statuses Select order status(es) that will be displayed in the drop shippable tab (Hold CTRL to select multiple statuses)
Allow Drop ship if product is in stock in your warehouses Allow to drop ship orders even if you already have ordered items in stock
Require drop shippable Allow drop ship only for products having the “drop ship” option set to yes in the supplier / product association (ERP view of a product > Suppliers tab)
Allow Drop ship only for ERP Valid Orders Only orders with a valid status will be able to be Drop shipped
Check supplier stock Allow drop ship a product only if its supplier’s stock quantity is greater than zero
Default drop ship Mode Defines the default drop ship action for new drop ship order
Error email report Email address you want to use to get logs from Drop Shipping import errors

Drop shippable Router

This system replace the logic of Drop shippable orders : The only orders that will be drop shippable will be the ones reserved in the drop shippable warehouse

_images/Drop_shippable_Router.png
Field Value
Enable drop shippable router Enable/Disable the Drop Shipping router system
Default drop ship warehouse Select the warehouse used for Drop ships orders

Miscellaneous

In this panel, you can set additional options to apply to drop ship orders.

_images/Miscellaneous.png
Field Value
Display customer order options in the PDF sent to supplier If there are some order options, display them in the PDF sent to supplier
Display shipping address in tabs Displays customer shipping address for each order in the Drop Shippable tab
Display comments text-area Displays a comments text-area for each ordered product in the Drop Shippable tab
Create invoice on drop ship Automatically create an invoice anytime you process to a Drop ship
Notify customer on drop ship Send an email to the customer when his order has been Drop shipped

Automatic submit drop shippable orders

In Drop Shipping, drop shippable orders can be submitted automatically. This panel contains options to set this automatic process.

_images/Automatic_submit_drop_shippable_orders.png
Field Value
Enable Enable/Disable automatic submit of drop shippable orders
Mode Select the action executed by the automatic process. You can choose between all the Available actions for Drop Shippable tab
Best supplier selection Select a rule to choose which supplier will be selected in priority to process to Drop ships
Exclude too expensive supplier Exclude from the supplier selection the ones having a purchase price higher than the ordered items sell price without taxes
Exclude supplier without stock Suppliers with no stock are excluded from the supplier selection

Drop Shipping File import settings

In this panel, you can set options for supplier stock import in Drop Shipping.

_images/Drop_shipping_file_import_settings.png
Field Value
Allowed file extensions Set all the accepted extensions for import files. You must separate them with a coma
Prune logs delay Set the lifetime of the logs (in days). After that delay, they will be deleted
Imports will re-init cost and stock to zero of all products of this supplier before to use the new data of the import When doing a supplier stock import, all the products having an association product-supplier with this supplier will have their stock and cost reset to zero to avoid keeping old data (for example if some products are missing in the imported file)
Stock import will be done using ERP background tasks for warehouse stock update If you need to import a big supplier stock file, use this setting to do the stock update using cron system

Drop ship request email

In this panel, you can set options for drop ship request emails sent to suppliers.

_images/Drop_ship_request_email.png
Field Value
Email Sender Email account from where drop ship requests emails will be sent
Email Template for drop ship request Default template for drop ship request emails
Email Template for direct dropship Default template for direct drop ship emails
Copy To Email address that will receive a copy of all drop ship request emails. Leave blank if you don’t need it
Disable supplier notification Disable or not the supplier notification when a request email is sent
Attach PO PDF Attach or not Purchase Order PDF to drop ship request emails
Attach packing slip Attach or not packing slip to drop ship request emails

Price request Email

In this panel, you can set options for prices request emails sent to suppliers.

_images/Price_request_email.png
Field Value
Email Sender Email account used to send prices request emails
Email Template Default template for prices request emails
Copy To Email address that will receive a copy of all prices request emails. Leave blank if you don’t need it

Drop shippable carriers

In this panel, you can add extra carriers not defined yet in your Magento, in order to use them with Drop Shipping.

_images/Drop_shippable_carriers.png
Field Value
Additionnal carrier list List containing additionnal carriers for tracking import, in case of the shipping company is not part of your shipping methods. Carrier names must be separated by a ,.
Email Template Default template for prices request emails
Display only active carriers Ability or not to select disabled carriers for the tracking import

Supplier

This part of documentation is related to the Drop Shipping configuration at supplier level.

In fact, DropShipping extension is adding 3 tabs in Suppliers configuration :

In order to see these tabs, go to ERP > Purchasing > Suppliers and select a supplier.

Drop Shipping tab

Note

This tab is available at ERP > Purchasing > Suppliers > [Select a supplier] > Drop Shipping

Supplier notification

_images/Supplier_notification.png
Field Value
Communication mode Set the way you want to communicate with the supplier
Packing slip file format Set the format of the packing slip file that will be attached
Default shipping fees Set the default price for the shipment
Apply shipping fees per item Apply the shipping fees for each item. Total of shipping fees will be : [shipping fees for 1 product] x [products count]
Preferred method for this supplier Select the default mode for this supplier auto drop ships
Stock steps for auto import Fast up the stock import (if the supplier exact products quantity is not really important for you)

Note

Here is an example for the Stock steps for auto import with a setting “by 10” :

  • If the supplier provide a stock of 18, your stock will be 10, as the stock step is set “by 10”.
  • If the supplier provide a stock of 45, your stock will be updated to 40.

CSV file template

If you set the packing slip in CSV format, this configuration section will help you to set the CSV scheme.

_images/cd7458b588bae8e3e6680ef39a7d75a9.png
Field Value
Order row Scheme of orders rows in CSV
Order items now Scheme of ordered products rows in CSV
CSV Preview CSV preview regarding current settings for Order row and Order items now
Available codes All available codes allowed in Order row and Order items now with an example for each one (data retrieved from last shipment registred in Magento)

Here is a list of all Available codes :

Shipment Order (1/3) Order (2/3) Order (3/3) Order_item Customer Billing Payment (1/2) Payment (2/2)
shipment.entity_id order.entity_id order.store_to_base_rate order.customer_firstname order_item.entity_id customer.entity_id billing_address.entity_id payment.entity_id payment.echeck_account_name
shipment.store_id order.state order.store_to_order_rate order.customer_lastname order_item.parent_id customer.entity_type_id billing_address.parent_id payment.parent_id payment.cc_avs_status
shipment.total_weight order.status order.subtotal order.customer_middlename order_item.row_total customer.attribute_set_id billing_address.customer_address_id payment.base_shipping_captured payment.cc_number_enc
shipment.total_qty order.coupon_code order.subtotal_canceled order.customer_prefix order_item.price customer.website_id billing_address.quote_address_id payment.shipping_captured payment.cc_trans_id
shipment.email_sent order.protect_code order.subtotal_invoiced order.customer_suffix order_item.weight customer.email billing_address.region_id payment.amount_refunded payment.flo2cash_account_id
shipment.order_id order.shipping_description order.subtotal_refunded order.customer_taxvat order_item.qty customer.group_id billing_address.customer_id payment.base_amount_paid payment.paybox_request_number
shipment.customer_id order.is_virtual order.tax_amount order.ext_customer_id order_item.product_id customer.increment_id billing_address.fax payment.amount_canceled payment.address_status
shipment.shipping_address_id order.store_id order.tax_canceled order.ext_order_id order_item.order_item_id customer.store_id billing_address.region payment.base_amount_authorized payment.amount
shipment.billing_address_id order.customer_id order.tax_invoiced order.global_currency_code order_item.additional_data customer.created_at billing_address.postcode payment.base_amount_paid_online payment.cc_raw_request
shipment.shipment_status order.base_discount_amount order.tax_refunded order.hold_before_state order_item.description customer.updated_at billing_address.lastname payment.base_amount_refunded_online payment.cc_raw_response
shipment.increment_id order.base_discount_canceled order.total_canceled order.hold_before_status order_item.name customer.is_active billing_address.street payment.base_shipping_amount payment.customer_payment_id
shipment.created_at order.base_discount_invoiced order.total_invoiced order.order_currency_code order_item.sku customer.disable_auto_group_change billing_address.city payment.shipping_amount  
shipment.updated_at order.base_discount_refunded order.total_offline_refunded order.original_increment_id order_item.product.entity_id customer.firstname billing_address.email payment.amount_paid  
shipment.packages order.base_grand_total order.total_online_refunded order.relation_child_id order_item.product.entity_type_id customer.lastname billing_address.telephone payment.amount_authorized  
shipment.shipping_label order.base_shipping_amount order.total_paid order.relation_child_real_id order_item.product.attribute_set_id customer.middlename billing_address.country_id payment.base_amount_ordered  
shipping_address.entity_id order.base_shipping_canceled order.total_qty_ordered order.relation_parent_id order_item.product.type_id customer.prefix billing_address.firstname payment.base_shipping_refunded  
shipping_address.parent_id order.base_shipping_invoiced order.total_refunded order.relation_parent_real_id order_item.product.sku customer.suffix billing_address.address_type payment.shipping_refunded  
shipping_address.customer_address_id order.base_shipping_refunded order.can_ship_partially order.remote_ip order_item.product.created_at customer.password_hash billing_address.prefix payment.base_amount_refunded  
shipping_address.quote_address_id order.base_shipping_tax_amount order.can_ship_partially_item order.shipping_method order_item.product.updated_at customer.taxvat billing_address.middlename payment.amount_ordered  
shipping_address.region_id order.base_shipping_tax_refunded order.customer_is_guest order.store_currency_code order_item.product.has_options customer.default_billing billing_address.suffix payment.base_amount_canceled  
shipping_address.customer_id order.base_subtotal order.customer_note_notify order.store_name order_item.product.required_options customer.default_shipping billing_address.company payment.ideal_transaction_checked  
shipping_address.fax order.base_subtotal_canceled order.billing_address_id order.x_forwarded_for order_item.product.exclude_from_supply_needs   billing_address.address_id payment.quote_payment_id  
shipping_address.region order.base_subtotal_invoiced order.customer_group_id order.customer_note order_item.product.weight   billing_address.gift_message_id payment.additional_data  
shipping_address.postcode order.base_subtotal_refunded order.edit_increment order.created_at order_item.product.price   billing_address.tax_id payment.cc_exp_month  
shipping_address.lastname order.base_tax_amount order.email_sent order.updated_at order_item.product.name   billing_address.vat_id payment.cc_ss_start_year  
shipping_address.street order.base_tax_canceled order.forced_shipment_with_invoice order.total_item_count order_item.product.url_key   billing_address.vat_is_valid payment.echeck_bank_name  
shipping_address.city order.base_tax_invoiced order.gift_message_id order.customer_gender order_item.product.gift_message_available   billing_address.vat_request_id payment.method  
shipping_address.email order.base_tax_refunded order.payment_auth_expiration order.base_custbalance_amount order_item.product.max_resolution   billing_address.vat_request_date payment.cc_debug_request_body  
shipping_address.telephone order.base_to_global_rate order.paypal_ipn_customer_notified order.currency_base_id order_item.product.response_time   billing_address.vat_request_success payment.cc_secure_verify  
shipping_address.country_id order.base_to_order_rate order.quote_address_id order.currency_code order_item.product.meta_title     payment.cybersource_token  
shipping_address.firstname order.base_total_canceled order.quote_id order.currency_rate order_item.product.meta_description     payment.ideal_issuer_title  
shipping_address.address_type order.base_total_invoiced order.shipping_address_id order.custbalance_amount order_item.product.thumbnail     payment.protection_eligibility  
shipping_address.prefix order.base_total_invoiced_cost order.adjustment_negative order.is_hold order_item.product.small_image     payment.cc_approval  
shipping_address.middlename order.base_total_offline_refunded order.adjustment_positive order.is_multi_payment order_item.product.image     payment.cc_last4  
shipping_address.suffix order.base_total_online_refunded order.base_adjustment_negative order.real_order_id order_item.product.custom_design     payment.cc_status_description  
shipping_address.company order.base_total_paid order.base_adjustment_positive order.tax_percent order_item.product.options_container     payment.echeck_type  
shipping_address.address_id order.base_total_qty_ordered order.base_shipping_discount_amount order.tracking_numbers order_item.product.url_path     payment.paybox_question_number  
shipping_address.gift_message_id order.base_total_refunded order.base_subtotal_incl_tax order.hidden_tax_amount order_item.product.screensize     payment.cc_debug_response_serialized  
shipping_address.tax_id order.discount_amount order.base_total_due order.base_hidden_tax_amount order_item.product.meta_keyword     payment.cc_ss_start_month  
shipping_address.vat_id order.discount_canceled order.payment_authorization_amount order.shipping_hidden_tax_amount order_item.product.description     payment.echeck_account_type  
shipping_address.vat_is_valid order.discount_invoiced order.shipping_discount_amount order.base_shipping_hidden_tax_amnt order_item.product.short_description     payment.last_trans_id  
shipping_address.vat_request_id order.discount_refunded order.subtotal_incl_tax order.hidden_tax_invoiced order_item.product.custom_layout_update     payment.cc_cid_status  
shipping_address.vat_request_date order.grand_total order.total_due order.base_hidden_tax_invoiced order_item.product.status     payment.cc_owner  
shipping_address.vat_request_success order.shipping_amount order.weight order.hidden_tax_refunded order_item.product.tax_class_id     payment.cc_type  
  order.shipping_canceled order.customer_dob order.base_hidden_tax_refunded order_item.product.visibility     payment.ideal_issuer_id  
  order.shipping_invoiced order.increment_id order.shipping_incl_tax order_item.product.manufacturer     payment.po_number  
  order.shipping_refunded order.applied_rule_ids order.base_shipping_incl_tax order_item.product.contrast_ratio     payment.cc_exp_year  
  order.shipping_tax_amount order.base_currency_code order.stocks_updated order_item.product.ordered_qty     payment.cc_status  
  order.shipping_tax_refunded order.discount_description order.fullstock_date order_item.product.reserved_qty     payment.echeck_routing_number  
  order.anounced_date order.payment_validated order.estimated_shipping_date order_item.product.group_price_changed     payment.account_status  
  order.anounced_date_max order.is_valid   order_item.product.tier_price_changed     payment.anet_trans_method  
  order.payment_authorization_expiration order.coupon_rule_name   order_item.product.is_in_stock     payment.cc_debug_response_body  
  order.forced_do_shipment_with_invoice order.base_shipping_hidden_tax_amount   order_item.product.is_salable     payment.cc_ss_issue  

Stock Price import tab

Note

This tab is available at ERP > Purchasing > Suppliers > [Select a supplier] > Stock / Price import

You’ll find there all information regarding supplier stock and price import.

There are two ways to import supplier’s stock and product prices :

  • Automatically using FTP
  • Manually using a local file

FTP Import

This is the easiest way to import a stock/price file as it is schedulable using the cron (just set Enable cron to “Enable”). All you have to do is to configure the FTP account and add the File Path.

File Import

You can use a manual import using a file. Just choose a file and start the process.

Formatting the file

The file must be build following the following rules :

  • one product per line
  • each line must contains a sku, a quantity, and a price, always in the same sequence.
  • The line informations are separated from each other by a single field separator.

These rules must be configured in “Csv file Settings”.

Example

Let’s assume we have the following file : SKU;Stock;Price SKU-001;16;12.8 SKU-002;12:223.20 SKU-003;8;1.5 The configuration must be like this :

_images/50e854a042b2d9e13719d1522cbe2055.png

The reason we skip the first line is because we have a header so we don’t want it to be red.

If you want to import you supplier SKU instead of your SKU, you have to chosse whne you configure the import

In the option “Product matching method”

  • set to “sku” if you want to use your sku
  • set it to “supplier sku” if you want to use the “supplier sku”

Note

Note : It is not possible to have sku and supplier sku mixed into the same file

Let’s choose a target warehouse and click on Process regarding the way you want to import the file (FTP or manual).

Note

Note : The target warehouse can’t be the default warehouse. You’ll have to create a new one. Most of the time you’ll want to create a dedicated warehouse for the suppliers.

Stock file import Log tab

See also

ERP > Purchase > Supplier > [ Select a supplier ] > Stock file import Log

_images/dbbb36a466ff868b9c8b9b7a7b496e01.png

This screen shows the recent import logs. When you perform an import, you are automatically redirected to this screen so you are able to check if everything went fine or not. It’s easy to make some mistakes in this process, so it will help you to find what’s wrong with the files.

You can quickly have a look at the file by clicking on Download file.

Logs are not permanent. They are deleted after the period you defined in the dropship configuration.