Attribute update price

[mjmartino]

Hi Jan
How to mass update attribute price ?
Or specific group.
Entering each product one at a time takes many days.

Any SQL or script will be helpful to update be SKU (product) / Name something.

Regrards.

[Jan]

Hi, what do you exactly mean with "attribute price"?

[mjmartino]

I mean Jan,

Update price = amount i DB attribute.
Case:
If i have example 1 products + 5 attributes and sub 10 = 1 main price + 50 amount price attribute.
200*50 = 10k to change amount (price)
Entering the product one by one and changing prices (amount attribute) is a job that takes many weeks.

I have additional question. we have now in table attribute 25k records.
I think some of them may be remnants of removed products? Is there any way to check this and remove unused/unassigned product attributes?

[Jan]

Hi, for now, I don't have any info about some script, etc, which can clean the table, so for this e.g. some specific SQL needs to be created

I don't fully understan this: "If i have example 1 products + 5 attributes and sub 10 = 1 main price + 50 amount price attribute.
200*50 = 10k to change amount (price)"
There is a bulk price change in Phoca Cart but not such detailed feature for attribute prices, so even for this there needs to be some specific SQL for this purpose

Jan

[mjmartino]

okey.
Very simple example.
I have t-shirt
T-shirt cost 10$
I have attribute S,M,L and color RED, PINK, BLACK,
S = +0,10 (amount)
M = +0,30 (amount)
L = +0,50 (amount)
RED = +1$ (amount)
PINK = +2$ (amount)
BLACK = +3$ (amount)

Now i want increase SML + 10% and RED, PINK, BLACK increase 5%


In PC we have only bulk to change price main. 10$
If i want update price (amount) this same metod i There's no such option. Only manual.

Now imagine a store with an assortment where there are thousands of attributes.
There is no tool that will allow this.
e.g., search for an attribute by name or other element and change it to AMOUNT.
If you have 100 products and 5 attributes under each product, manual change takes 4-5 days.

Now I do it via phpmyadmin - SQL collecting the group ID and then updating.
But it's easy to make a mistake.

Should be something similar tool like Bulk Price but for Attribute (amount).

If someone has an average of over 100 products with attributes. A lot of time is wasted by raising or lowering prices in attributes.

[Jan]

Hi, OK, thank you for the info. I will take a look at it. BTW why don't you use "Advanced Stock Management" where sou can set prices for each variant?

Jan