MRobo Posted May 27, 2016 Share Posted May 27, 2016 Hi there, I am having difficulties with my pricing for combinations. I have 6000+ products in a .csv that I need to add with combinations. The prices for combinations in my .csv are the actual prices for each attribute, and are not an increase value from the base price of the product. Without manually editing (NOPE, HELL WILL FREEZE FIRST) each combination price to equal the increase in price, rather than the absolute price for the option, I cannot add the prices for each combination. For example: Product 1 $10 -Option 1 $12 Becomes $22 instead of $12 when option 1 is selected. I realize if I set Option 1 to $2 it would produce the desired result, but I refuse to manually edit 6000 entries. How do I modify, change, or downright extort prestashop into displaying combination price as the absolute price instead of adding it on to the base price? I have also spent hours trying to find an automatic or semiautomatic method to change the combination price in my .csv to be the increase value without any luck. Here is the format I am working with: Product Reference | Combination Reference | Price --------------------------------------------------------------------------------------- 1111111 | | 2.00 --------------------------------------------------------------------------------------- 1111111 | AAA11111111111 | 2.50 --------------------------------------------------------------------------------------- 1111111 | AAA2222222222 | 2.75 --------------------------------------------------------------------------------------- 1111111 | AAA3333333333 | 2.99 --------------------------------------------------------------------------------------- 2222222 | | 4.00 --------------------------------------------------------------------------------------- 2222222 | BBB1111111111 | 4.50 --------------------------------------------------------------------------------------- 2222222 | BBB222222222 | 4.75 --------------------------------------------------------------------------------------- 2222222 | BBB333333333 | 4.99 Something in the price field like (C3) = C3-B2 to end up with a value of 0.5. The problem is I still need to input this ~3000 times just for this file alone. I also have a file with just the Product reference and base price. I thought of lining up the base price based on the Product ID, say in column D and create a formula to change the combination price to the difference, but cannot line them up as there are multiple rows per product reference. Some help would be great. Thanks Link to comment Share on other sites More sharing options...
Atomico Posted September 13, 2017 Share Posted September 13, 2017 Hi, you can set the main product price at 0€..and set the absolute price in combinations. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now