Phoca Forum

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.

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

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?

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

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.

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

For my case this doesn't fit/work.
Example i don't want product and attribute one attribute to switch i variants. (too many)
Pergola 300x400 this is one product pergola 300x450 is another. 300x500 is another. etc.
Because we already have additional things in attributes such as COLORS, INSTALLATION, BEAMS etc.
We want to minimize the number of choosing attributes.
So using ACM doesn't really give us anything and doesn't speed up our work.

The price was increased (amount attribute) only for specify group attributes other than COLOR and ASSEMBLY.