Products: GBAP15
Decimal separator is a full stop. Detailed product format, semicolon separated.
‘StdReg_xxx.xls’:‘StdReg_xxx.xls’: Read more in Default Values in Mamut Business Software.
| Description | Column no. | Column in Excel | Max length | Comments | Required |
|---|---|---|---|---|---|
|
Identification |
0 |
A |
6 |
Always: GBAP15 |
Yes |
|
Product number |
1 |
B |
50 |
Text |
Yes |
|
Description/name |
2 |
C |
60 |
Text |
Yes |
|
Unit |
3 |
D |
20 |
Text |
|
|
Weight |
4 |
E |
10 |
Numeric (up to 3 decimals) |
|
|
Volume |
5 |
F |
10 |
Numeric (up to 3 decimals) |
|
|
Cost price (excl. VAT) |
6 |
G |
10 |
Numeric (up to 4 decimals). |
|
|
Sales price (excl. VAT) |
7 |
H |
10 |
Numeric (up to 4 decimals). |
|
|
Output VAT code |
8 |
I |
5 |
Numeric (StdReg_xxx.xls) |
|
|
Product group |
9 |
J |
5 |
Numeric (StdReg_xxx.xls) |
|
|
Subgroup |
10 |
K |
5 |
Numeric (StdReg_xxx.xls) |
|
|
Purchase price (excl. VAT) |
11 |
L |
15 |
Numeric (up to 4 decimals). |
|
|
Supplier’s product number |
12 |
M |
25 |
Text. If the product is connected to more than one supplier, only the default supplier’s product number will be updated. |
|
|
Stock |
13 |
N |
12 |
Numeric (up to 2 decimals) |
|
|
Default warehouse |
14 |
O |
4 |
Numeric (StdReg_xxx.xls) |
|
|
Input VAT code |
15 |
P |
3 |
Numeric (StdReg_xxx.xls) |
|
|
EAN code |
16 |
Q |
20 |
Text |
|
Read more about: