This feature allows you to save time when implementing Simple ERP in your company, or when updating products (rapid price changes for a large number of products for example).
To import products into Simple ERP, follow the steps below.
1) Prerequisites
You must of course have subscribed to the optional Simple ERP module. If you have not already done so, go to this page to know the price of the module.
you must have already configured Simple ERP (see details on this page)
we strongly advise you to use the free LibreOffice software to fill in and save the file
2) Creation of the CSV product file
First download the product import file template.
To do this, go to the Simple ERP module (top menu -> Simple ERP), then click on the "Product" icon in the top menu.
Click on the link in red "file template", then open the file with LibreOffice software.
Now complete the file. Here are the details of the columns:
Column A : reference
This is the unique product reference. This field is required.
If the reference already exists in Simple ERP, the product will be updated with the values from the file line.
Column B : warehouse_code
This is the warehouse code in which the product is stored.
This field is not required. If the cell is empty, the default warehouse will be assigned to the product.
Column C : ref_vendor
This is the reference of this product at your supplier.
This field is not required.
Column D: description
This is the name of the product. This field is required.
This wording will appear in the commercial documents generated with Simple ERP.
Column E : category
This is the name of the product category. This field is required.
If the category does not exist in Simple ERP, it will be created and assigned to the product.
Column F : unit
This is the abbreviation for the product unit. Example : U (unit), H (hour), KG (kilogram)...
This field is not required. If it is empty, the U unit (unit) will be assigned to the product.
Column G : unit_sale_price
This is the unit selling price of the product. This field is required. If the product price is variable, enter 0 in this cell.
Column H: unit_purchase_price
This is the unit purchase price of the product.
Column I : VAT code
This is the VAT code you entered in tax rate management (Simple ERP -> Admin ERP -> 4. Tax management)
Column J : note
This is the detailed product description, which will be applied to the product line commentary in the ERP documents.
Column K : Stock
This is the initial stock of the product. This field is required. If the stock is empty or if you do not manage stock for the product, enter 0 in this cell.
Column L : stock_mini
This is the minimum stock of the product. This field is required. If the stock is empty or if you do not manage stock for the product, enter 0 in this cell.
Column M : maximum_stock
This is the maximum stock of the product. This field is required. If the stock is empty or if you do not manage stock for the product, enter 0 in this cell.
Column N : stock_management
This is the stock management for the product. This field is required. Enter 1 if you want to manage stock for this product, and 0 if you do not want to manage stock.
Column O : code_tva_achat
This is the VAT code for the purchase that you entered in tax rate management (Simple ERP -> Admin ERP -> 4. Tax management)
Columns P to W : PROD_RESERVEX
These columns are reserved for future use in Simple ERP.
Columns X to AU : PROD_CUSTXX
These are the custom fields that you may have created on the product sheets.
See FAQ: http://www.simple-crm-support.com/2016/09/creer-des-champs-personnalises-avec.html
No comments:
Post a Comment
We will usually reply within 04 – 24 hours (but Saturday and Sunday)