Wiki source code of PRICES in Excel

Last modified by TESU on 2017/10/11 09:51

Content · Comments (0) · Attachments (1) · History · Information

Hide line numbers

 1: **NB! **You can upload product information to Telema without prices. In this case your clients will only see product information without any indication for the price.
 2: 
 3: You should use sheet "Prices" only in case your company wants to set specific prices, assortments to customers. In case you only use base price, send the price information with sheet "Products".
 4: 
 5: Following fields can be filled about prices/assortments:
 6: 
 7: * Customer code - customer code in your ERP (also the link code in Telema system. Code can be checked at Partners page in Portal). If the prices are the same for all customers write MATNR as the code. (% style="color:#ff0000;" %)**REQUIRED**
 8: * Product code - code for the product, (% style="font-size: 14px; font-style: normal; font-weight: 700; text-align: start; line-height: 19.600000381469727px; color: rgb(255, 0, 0);" %)REQUIRED
 9: * GTIN
10: * Sales price -final price of product for customer without VAT, (% style="font-size: 14px; font-style: normal; font-weight: 700; text-align: start; line-height: 19.600000381469727px; color: rgb(255, 0, 0);" %)REQUIRED
11: * Disc - discount rate for product for customer
12: * VAT rate - (without the %-symbol) (% style="font-size: 14px; font-style: normal; font-weight: 700; text-align: start; line-height: 19.600000381469727px; color: rgb(255, 0, 0);" %)REQUIRED
13: * VAT type - TAX or NOTTAX (% style="font-size: 14px; font-style: normal; font-weight: 700; text-align: start; line-height: 19.600000381469727px; color: rgb(255, 0, 0);" %)REQUIRED
14: * Currency - EUR (% style="font-size: 14px; font-style: normal; font-weight: 700; text-align: start; line-height: 19.600000381469727px; color: rgb(255, 0, 0);" %)REQUIRED
15: * Start date - you can set price validity start date
16: * End date - you can set price validity end date
17: 
18: In case you use MMT then in addtion:
19: 
20: * Min order quantity - you can set minimum order quantity of product for all customers or for specific customer.
21: 
22: In case you use VMI then in addition:
23: 
24: * Min stock quantity - you can set minimum amount of products at customers side
25: * Max stock quantity - you can set maximum amount of products at customers side
26: 
27: **RULES**
28: 
29: * Following fields should be filled about prices:
30: ** customer code
31: ** sales price or discount rate
32: ** currency
33: ** VAT rate
34: ** VAT type
35: 
36: (((
37: (% style="line-height: 19.600000381469727px;" %)[[image:EAS.jpg]]
38: )))