How to add shopper's group prices

User Rating: / 0
PoorBest 
  1. Shopper groups need to exist in VM

  2. Using VMCClient, in the product TAB, click on “Refresh Shopper Groups” button

  3. When Shopper groups from VM appeared, select the Shopper group ID line you want to download

  4. Download the products Shopper_group_id column should right

  5. Export to products to MS Excel

  6. 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.

  7. Then import into VMCClient and upload to VM.

  8. Each product line must have the command : productUpdate

  9. 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

 

Join our mailing list!

Sign up to our mailing list and stay up to date!



YouTube Channel

youtube

Check out the official JoomConnector YouTube channel for product demos, tutorials and screencasts!