How to add shopper's group prices
-
Shopper groups need to exist in VM
-
Using VMCClient, in the product TAB, click on “Refresh Shopper Groups” button
-
When Shopper groups from VM appeared, select the Shopper group ID line you want to download
-
Download the products Shopper_group_id column should right
-
Export to products to MS Excel
-
Change the prices accordingly:
-
Leave the fields “price_quantity_start” and the “price_quantity_end” equal to zero (0)
-
The “price_id” must be empty as VMConnector will create an ID for each.
-
“price” is required
-
“price_incl_tax” is not required will be downloaded according to “tax_id”
-
“currency” is required
-
“tax_id” must correspond to “tax_rate” (information only here) which must have been entered in VM administration screen.
-
-
Then import into VMCClient and upload to VM.
-
Each product line must have the command : productUpdate
-
TIP: Download products with existing prices for a shopper group, then replace RED fields with corresponding values and upload to VM.
|
shopper_group_id |
price_quantity_start |
price_quantity_end |
price_id |
price |
price_incl_tax |
currency |
tax_id |
tax_rate |
|
6 |
0 |
0 |
|
50 |
5.401675 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
51 |
54.114175 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
52 |
27.051675 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
53 |
21.639175 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
54 |
27.051675 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
55 |
1.0825 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
56 |
162.364175 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
57 |
239.12425 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
58 |
52.0899 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
59 |
81.176675 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
60 |
86.589175 |
USD |
2 |
0.0825 |
|
6 |
0 |
0 |
|
61 |
49.99 |
USD |
0 |
0 |
|
6 |
0 |
0 |
|
62 |
59.99 |
USD |
0 |
0 |

