Import Products With Various Client Groups

[rafamerida]

We have several product listings that need to be imported in Prestashop 1.5.3.

 

For our product table, we have 3 different client groups, which have different prices per product.

ej. A, B and C; these groups have not common discounts, the price is always set per each product.

 

That doesn't allow to set up a constant or percentual discount between each of the groups, because in a product we can have 15% discounted, maybe other have 5%, there's not a constant discount.

 

For example:

 

PRODUCT 1.

-------------------

Rate A price: 70€

Rate B price: 51€

Rate C price: 45€

 

PRODUCT 2.

-------------------

Rate A price: 70€

Rate B price: 60€

Rate C price: 51€

 

The problem is that, for the kind of prices we have, we can't make a rule to discount X% to group B or C. Each product must have 3 columns for specific prices.

 

And have about 500 products, when tried to import products, the Prestashop assistant allows to import the data properly, but only prices from column A, as "Prices including TAX", which is great, it saves a lot of time, but how could I import prices for groups B and C?

 

Looked for premium modules already, but nothing seems to match my needs. Also considering the option of insert data into MYSQL table, if any could help?