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
Using the screen
Access: Tools → Administration → Data import → Import supplier prices, or context menu of the supplier prices screen (if admin)
This program is reserved for users with administrative privileges. As with all programs performing mass updates, it is recommended to make a backup of the database before use, or to carry out the operation on a test database before launching the operation on a production database.
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