Import supplier price

A1 proofreading not yet effective for this page. In the meantime, you can ask any questions on the forum.

When you sell products all or part of which are manufactured by another company, you regularly receive prices from these suppliers, generally in the form of a spreadsheet (Excel, Libre Office, etc.).

This screen allows

• a mass update of your supplier purchase prices
• easy updating of the purchase price, in your own tariff

Access: Tools → Administration → Data import → Import supplier prices, or context menu of the supplier prices screen (if admin)

Select the one of your suppliers for which you received the price via the Supplier combo.

You can specify in VAT default the VAT rate that would be applied if no rate was specified in the data, and in Tx margin the margin rate that would be applied to the sales price from purchase price, in the creation of a new product.

If you check the Creation new box, the price products which are not yet in your catalog will be created. An additional screen will ask you for the default creation family/subfamily.

Then select one of the two options available on the Load button.

• New file, to open a preformatted spreadsheet
• Open, to open a pre-existing spreadsheet

If you had chosen New file, the spreadsheet displays a preformatted file as below.

Simply enter in the columns:

• CD_PRODUIT_FOU: the supplier product code (required)
• PU_ACHAT_HT: the new purchase price of the product from your supplier (required)

You can also enter:

• PU_VENTE_HT: the sales price excluding tax
• TX_TVA_ACHAT: the purchase VAT rate
• TX_REM_FOU: the supplier discount rate
• LIB_PRODUIT: the label of the product (optional. Allows you to feed the label into the creation of a new product, or to update it)
• BRAND: the brand
• EAN13: the EAN13 code (barcode)
• DELAI_LIVR_FOU: the supplier delivery time

If a column is not useful to you, delete it entirely.

On the spreadsheet screen, the Validate button will populate the table with the operations to be carried out.

The Remove button allows you not to process the lines you have selected.

In the example above:

• the “PEAR” rate will not be changed, because the new rate is the same as the old one
• the “CAR-1” rate will be updated
• “RADIS” and “BRX” products will be created.

You can modify the margin rate, or the sales price, in the table.

The context menu allows you to apply, for the selected lines:

• or the previous margin rate,
• either the objective margin rate of the product,
• or any other margin rate.

The Validate button will start processing.

Other “Products” articles