3. Configuration

1. Drop shipping

1. Drop shippable orders

The dropshippable orders are the orders that contains at least one product that can be dropshipped. These orders are eligible to be displayed in the dropship module.

This screen allows you to control that flow by applying filters.

_images/88a8b185d2eaa3279c191fa591e4375a.png

Display order with status : The status of the orders to display in drop shippable tab (Hold CTRL)

Display orders with stock : If enable, you’ll be able to dropship orders even if you have the product in stock

Check supplier stock : If enable, you’ll be able to dropship product if stock > 0

Require drop shippable : If enable, you’ll be able to dropship only the products that are configured as dropshippable

Error email report :   The email address you wish to get import errors

Default Dropship Mode : The default dropship action on a new dropship

2. Available actions for drop shippable tab

_images/0f4c81c81feab47e7925fa85322eff78.png

Create purchase order : Enable/Disable creating a purchase order when requesting a dropship.

Price request : Enable/Disable the step that ask the supplier for the price of the products.

Drop ship : Enable/Disable the step that do a dropship directly.

Drop ship request : Enable/Disable the step that ask the supplier for a dropship.

3. Price response confirmation

_images/c91a5c5532b420d3d0f2ccecb02f17ad.png

Action : Choose the new step after a confirmation of price from the supplier.

Drop ship request : Will do a request for the supplier to handle the shipment

Dropship : Will do a dropship without waiting any confirmation from the supplier.

4. Tabs to display

_images/8a18657365bc47c5c814ffda3b573fdf.png

Display pending supplier response : Enable/disable the pending supplier response tab.

Display pending price response : Enable/disable the pending price response tab.

Display shipping Confirmation : Enable/disable the confirmation tab.

Display drop shipped history : Enable/disable the shipped history tab.

5. Automatic submit drop shippable orders

_images/038dad2ef0d3b29db5322ef7a0d3d2c0.png

Enable : Enable/Disable the automatic submit for dropshippable orders.

Mode : The action executed by the automatic submit.

6. Miscellaneous

_images/8f560f217d85da862bd7e2c0522e29f3.png

Display comments textarea : Enable/Disable the comments textarea

Create invoice on drop ship : Enable/Disable the creation of the invoice when you process the dropship

Notify customer on drop ship : Enable/Disable the shipment email to customer when order is dropshipped

Require drop shippable and Check Supplier Stock options

One of the good practice is to set which products are dropshippable using the “association product supplier” in ERP

Set pps_can_dropship field to 1 (the import can do that for you in mass)

You can also set the supplier stock in pps_quantity_product

it will allows you to create a link between a product and a supplier.

If you have correctly filled pps_can_dropship field check the option in System > Configuration > ERP > DropShipping > Miscellaneous > Require drop shippable > Yes

If you have correctly filled pps_quantity_product field check the option in System > Configuration > ERP > DropShipping > Miscellaneous > Check Supplier Stock  > Yes

7. Drop Shipping File import settings

_images/c24f9674665c21cd6d2062ff7f049e15.png

Allowed file extensions : Set all the extensions that you want to be accepted. 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.

8. Drop ship request email

_images/2849f8ec3f2123f56cb4dd6109fcac11.png

Email Sender : The email account you want to send email with.

Email Template : The email template you want to set as default email when you request prices to a supplier.

Copy To : The email address that will receive a copy. Leave blank if you don’t need it.

Disable supplier notification : Enable/Disable the notifications to the supplier.

Attach packing slip : Enable/Disable the attachment of the packing slip to the dropship request email.

Attach PO PDF : Enable/Disable the attachment of the Purchase Order to the dropship request email.

9. Price request Email

_images/8bd3e840af7816be1e7c237282f34240.png

Email Sender : The email account you want to send email with.

Email Template : The email template you want to set as default email when you request prices to a supplier.

Copy To : The email address that will receive a copy. Leave blank if you don’t need it.

2. Supplier

1. Drop Shipping

See also

ERP > Purchase > Supplier > [ Select a supplier ] > Drop Shipping

Supplier notification

_images/ca43a1bd37e551a5e074694fb49091b6.png

Communication mode : Set the way you want to communicate with this 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 : Enable / Disable summing shipping fees for each products. (shipping fees = shipping fees for 1 product  x  products count).

CSV file template

If you choose a packing slip in CSV format, you can define there how it will be formatted.

_images/cd7458b588bae8e3e6680ef39a7d75a9.png

Order row : Define the scheme the orders must follow when exported to CSV (see example below).

Order items now : Define the scheme the order items must follow when exported to CSV (see example below).

CSV Preview : Shows a preview of the template set using values defined below.

Available codes : Shows all the available codes allowed in templates, and an example of value (used in preview).

Shipment

Order

Customer

Billing

Payment

shipment.entity_id

shipment.store_id

shipment.total_weight

shipment.total_qty

shipment.email_sent

shipment.order_id

shipment.customer_id

shipment.shipping_address_id

shipment.billing_address_id

shipment.shipment_status

shipment.increment_id

shipment.created_at

shipment.updated_at

shipment.packages

shipment.shipping_label

shipping_address.entity_id

shipping_address.parent_id

shipping_address.customer_address_id

shipping_address.quote_address_id

shipping_address.region_id

shipping_address.customer_id

shipping_address.fax

shipping_address.region

shipping_address.postcode

shipping_address.lastname

shipping_address.street

shipping_address.city

shipping_address.email

shipping_address.telephone

shipping_address.country_id

shipping_address.firstname

shipping_address.address_type

shipping_address.prefix

shipping_address.middlename

shipping_address.suffix

shipping_address.company

shipping_address.address_id

shipping_address.gift_message_id

shipping_address.tax_id

shipping_address.vat_id

shipping_address.vat_is_valid

shipping_address.vat_request_id

shipping_address.vat_request_date

shipping_address.vat_request_success

order.entity_id

order.state

order.status

order.coupon_code

order.protect_code

order.shipping_description

order.is_virtual

order.store_id

order.customer_id

order.base_discount_amount

order.base_discount_canceled

order.base_discount_invoiced

order.base_discount_refunded

order.base_grand_total

order.base_shipping_amount

order.base_shipping_canceled

order.base_shipping_invoiced

order.base_shipping_refunded

order.base_shipping_tax_amount

order.base_shipping_tax_refunded

order.base_subtotal

order.base_subtotal_canceled

order.base_subtotal_invoiced

order.base_subtotal_refunded

order.base_tax_amount

order.base_tax_canceled

order.base_tax_invoiced

order.base_tax_refunded

order.base_to_global_rate

order.base_to_order_rate

order.base_total_canceled

order.base_total_invoiced

order.base_total_invoiced_cost

order.base_total_offline_refunded

order.base_total_online_refunded

order.base_total_paid

order.base_total_qty_ordered

order.base_total_refunded

order.discount_amount

order.discount_canceled

order.discount_invoiced

order.discount_refunded

order.grand_total

order.shipping_amount

order.shipping_canceled

order.shipping_invoiced

order.shipping_refunded

order.shipping_tax_amount

order.shipping_tax_refunded

order.store_to_base_rate

order.store_to_order_rate

order.subtotal

order.subtotal_canceled

order.subtotal_invoiced

order.subtotal_refunded

order.tax_amount

order.tax_canceled

order.tax_invoiced

order.tax_refunded

order.total_canceled

order.total_invoiced

order.total_offline_refunded

order.total_online_refunded

order.total_paid

order.total_qty_ordered

order.total_refunded

order.can_ship_partially

order.can_ship_partially_item

order.customer_is_guest

order.customer_note_notify

order.billing_address_id

order.customer_group_id

order.edit_increment

order.email_sent

order.forced_shipment_with_invoice

order.gift_message_id

order.payment_auth_expiration

order.paypal_ipn_customer_notified

order.quote_address_id

order.quote_id

order.shipping_address_id

order.adjustment_negative

order.adjustment_positive

order.base_adjustment_negative

order.base_adjustment_positive

order.base_shipping_discount_amount

order.base_subtotal_incl_tax

order.base_total_due

order.payment_authorization_amount

order.shipping_discount_amount

order.subtotal_incl_tax

order.total_due

order.weight

order.customer_dob

order.increment_id

order.applied_rule_ids

order.base_currency_code

order.customer_email

order.customer_firstname

order.customer_lastname

order.customer_middlename

order.customer_prefix

order.customer_suffix

order.customer_taxvat

order.discount_description

order.ext_customer_id

order.ext_order_id

order.global_currency_code

order.hold_before_state

order.hold_before_status

order.order_currency_code

order.original_increment_id

order.relation_child_id

order.relation_child_real_id

order.relation_parent_id

order.relation_parent_real_id

order.remote_ip

order.shipping_method

order.store_currency_code

order.store_name

order.x_forwarded_for

order.customer_note

order.created_at

order.updated_at

order.total_item_count

order.customer_gender

order.base_custbalance_amount

order.currency_base_id

order.currency_code

order.currency_rate

order.custbalance_amount

order.is_hold

order.is_multi_payment

order.real_order_id

order.tax_percent

order.tracking_numbers

order.hidden_tax_amount

order.base_hidden_tax_amount

order.shipping_hidden_tax_amount

order.base_shipping_hidden_tax_amnt

order.hidden_tax_invoiced

order.base_hidden_tax_invoiced

order.hidden_tax_refunded

order.base_hidden_tax_refunded

order.shipping_incl_tax

order.base_shipping_incl_tax

order.coupon_rule_name

order.stocks_updated

order.fullstock_date

order.estimated_shipping_date

order.payment_validated

order.is_valid

order.anounced_date

order.anounced_date_max

order.payment_authorization_expiration

order.forced_do_shipment_with_invoice

order.base_shipping_hidden_tax_amount

order_item.entity_id

order_item.parent_id

order_item.row_total

order_item.price

order_item.weight

order_item.qty

order_item.product_id

order_item.order_item_id

order_item.additional_data

order_item.description

order_item.name

order_item.sku

order_item.product.entity_id

order_item.product.entity_type_id

order_item.product.attribute_set_id

order_item.product.type_id

order_item.product.sku

order_item.product.created_at

order_item.product.updated_at

order_item.product.has_options

order_item.product.required_options

order_item.product.exclude_from_supply_needs

order_item.product.weight

order_item.product.price

order_item.product.name

order_item.product.url_key

order_item.product.gift_message_available

order_item.product.max_resolution

order_item.product.response_time

order_item.product.meta_title

order_item.product.meta_description

order_item.product.thumbnail

order_item.product.small_image

order_item.product.image

order_item.product.custom_design

order_item.product.options_container

order_item.product.url_path

order_item.product.screensize

order_item.product.meta_keyword

order_item.product.description

order_item.product.short_description

order_item.product.custom_layout_update

order_item.product.status

order_item.product.tax_class_id

order_item.product.visibility

order_item.product.manufacturer

order_item.product.contrast_ratio

order_item.product.ordered_qty

order_item.product.reserved_qty

order_item.product.group_price_changed

order_item.product.tier_price_changed

order_item.product.is_in_stock

order_item.product.is_salable

customer.entity_id

customer.entity_type_id

customer.attribute_set_id

customer.website_id

customer.email

customer.group_id

customer.increment_id

customer.store_id

customer.created_at

customer.updated_at

customer.is_active

customer.disable_auto_group_change

customer.firstname

customer.lastname

customer.password_hash

customer.prefix

customer.middlename

customer.suffix

customer.taxvat

customer.default_billing

customer.default_shipping

billing_address.entity_id

billing_address.parent_id

billing_address.customer_address_id

billing_address.quote_address_id

billing_address.region_id

billing_address.customer_id

billing_address.fax

billing_address.region

billing_address.postcode

billing_address.lastname

billing_address.street

billing_address.city

billing_address.email

billing_address.telephone

billing_address.country_id

billing_address.firstname

billing_address.address_type

billing_address.prefix

billing_address.middlename

billing_address.suffix

billing_address.company

billing_address.address_id

billing_address.gift_message_id

billing_address.tax_id

billing_address.vat_id

billing_address.vat_is_valid

billing_address.vat_request_id

billing_address.vat_request_date

billing_address.vat_request_success

payment.entity_id

payment.parent_id

payment.base_shipping_captured

payment.shipping_captured

payment.amount_refunded

payment.base_amount_paid

payment.amount_canceled

payment.base_amount_authorized

payment.base_amount_paid_online

payment.base_amount_refunded_online

payment.base_shipping_amount

payment.shipping_amount

payment.amount_paid

payment.amount_authorized

payment.base_amount_ordered

payment.base_shipping_refunded

payment.shipping_refunded

payment.base_amount_refunded

payment.amount_ordered

payment.base_amount_canceled

payment.ideal_transaction_checked

payment.quote_payment_id

payment.additional_data

payment.cc_exp_month

payment.cc_ss_start_year

payment.echeck_bank_name

payment.method

payment.cc_debug_request_body

payment.cc_secure_verify

payment.cybersource_token

payment.ideal_issuer_title

payment.protection_eligibility

payment.cc_approval

payment.cc_last4

payment.cc_status_description

payment.echeck_type

payment.paybox_question_number

payment.cc_debug_response_serialized

payment.cc_ss_start_month

payment.echeck_account_type

payment.last_trans_id

payment.cc_cid_status

payment.cc_owner

payment.cc_type

payment.ideal_issuer_id

payment.po_number

payment.cc_exp_year

payment.cc_status

payment.echeck_routing_number

payment.account_status

payment.anet_trans_method

payment.cc_debug_response_body

payment.cc_ss_issue

payment.echeck_account_name

payment.cc_avs_status

payment.cc_number_enc

payment.cc_trans_id

payment.flo2cash_account_id

payment.paybox_request_number

payment.address_status

payment.amount

payment.cc_raw_request

payment.cc_raw_response

payment.customer_payment_id

2. Stock Price import

See also

Erp > purchase > supplier > Select a supplier > Stock / Price import

There are two ways to import a supplier stock and product prices : automatically via FTP or manually via a local file.

FTP Import

This is the easiest way to import a stock/price file as it can be scheduled 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 information 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 choose when 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

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

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.

3. Stock file import Log

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.