Apply same price to characteristics for products

  • Posts: 158
  • Thank you received: 6
12 years 9 months ago #42453

Hello,

I'd like to begin by saying how much I like this extension. I just began trying it yesterday for the first time and I'm very impressed!

Question: I am setting up a photography site where every product has the same 6 characteristics (size and print type). The price for these characteristics is the same for every photograph on the site. Right now, I have added the characteristic and created the 6 variants but I have to click on Manage Variants and add the value every time I add a new product. This is taking about 10 minutes per product. Is there any way (php or through the admin panel) to assign a permanent value to a characteristic?

Here are the screenshots:
Product Setup page: screencast.com/t/F6lj0oVTqF
Variants Setup Page: screencast.com/t/IryHNBqloou5
Assign a price to Variant: screencast.com/t/MtrLCQevOc
Next Product - what happens when I try to add the same characteristics - all variant values are reset: MtXUSxzVPQe

website: king.artisanwebandprint.com

Thanks for your answers.

Dawn

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
12 years 9 months ago #42625

Hi,

If you use the Business edition, you have a copy button you can use on the products listing in order to duplicate a product.
That way, you will just have to change the image/name/description from one product to another instead of having to enter again all the pricing and other information for each product.

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
12 years 9 months ago #44232

Hello, we are using hikashop and send you our compliments for the extension : here below i found an issue that i was about to ask to you, we have the same problem:

you suggest the business version in your reply, ok no prob we are counting to do this in the near future, but how can we do a batch edit of pricing of our 6 main characteristics? that we apply to all our images? lets say that in a couple of months we want to adjust the pricing of all our photos that we sell at 8x12 ? can we edit only one field or we have to enter into each and every image manually ?


Thanks for your helpful support

Fabio
Duealberi
www.duealberi.com





artisanwebandprint wrote: Hello,

I'd like to begin by saying how much I like this extension. I just began trying it yesterday for the first time and I'm very impressed!

Question: I am setting up a photography site where every product has the same 6 characteristics (size and print type). The price for these characteristics is the same for every photograph on the site. Right now, I have added the characteristic and created the 6 variants but I have to click on Manage Variants and add the value every time I add a new product. This is taking about 10 minutes per product. Is there any way (php or through the admin panel) to assign a permanent value to a characteristic?

Here are the screenshots:
Product Setup page: screencast.com/t/F6lj0oVTqF
Variants Setup Page: screencast.com/t/IryHNBqloou5
Assign a price to Variant: screencast.com/t/MtrLCQevOc
Next Product - what happens when I try to add the same characteristics - all variant values are reset: MtXUSxzVPQe

website: king.artisanwebandprint.com

Thanks for your answers.

Dawn



..........................
Hi,

If you use the Business edition, you have a copy button you can use on the products listing in order to duplicate a product.
That way, you will just have to change the image/name/description from one product to another instead of having to enter again all the pricing and other information for each product.

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
12 years 9 months ago #44235

There is no batch edition in HikaShop for now.

However, you should be able to do such change quite easily with a mysql query via phpmyadmin if you really have a lot of them.
For example, suppose that your products with that characteristic cost 10€ and that you want them to cost 15€, you would run that query:
UPDATE jos_hikashop_price SET price_value=15 WHERE price_value=10;

The following user(s) said Thank You: DueAlberi

Please Log in or Create an account to join the conversation.

  • Posts: 152
  • Thank you received: 1
12 years 3 months ago #66197

Hiya Nicolas,

I'm no expert at mySQL but would I be able to do that via a multiplier? For example - I have added all the prices as wholesale prices and would like to adjust them by 50% could I multiply prices buy 1.5? or what?

UPDATE jos_hikashop_price SET price_value=10*1.5 WHERE price_value=10;

also what if I don't know what the price is or if I have a whole range of different prices?


Believe in Better

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
12 years 3 months ago #66438

You can do like that:
UPDATE jos_hikashop_price SET price_value=price_value*1.5;

That will multiply all the prices by 1.5.

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
11 years 2 months ago #125570

Hi, I have a similar problem. I've imported many products from virtuemart and want to add the same characteristics to them.
How would I run a mysql query where currently the value of each of 4 characteristics is not set but each characteristic needs to be a different value?
Or is there a way to do this via the mass action.
Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
11 years 2 months ago #125586

Hi,

Do you always have one value per characteristic per product ?
In that case, it should not be a characteristic but a custom product field.
The mass action system can allow you to add a characteristic to products (it will add all the variants of the characteristic). It can also allow to mass set the value of a custom product field.
But it can't fill automatically different values of a custom product field or a characteristic for different products since it doesn't know which one goes to which product. In that case, it would be faster to directly enter the value for each product than trying to apply a massaction for each product. Or am I missing something in your question ?

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
11 years 2 months ago #125596

Hi,
I have a monthly product, it has 4 options/characteristics with different prices, the 4 options/characteristics are the same each month, the price of each individual option/characteristic is the same each month.
So when I create next month's product I want to be able to just add the characteristic and have the prices appear the same as last month.
My main problem is I've imported over 200 products and as well as adding the characteristic to them, I'm also having to set up the prices for each variant each time even though they are the same for all.
Is there a quicker way to do this?
Is custom product field a better option?

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
11 years 2 months ago #125600

Hi,

In that case, to create next month products, simply select your current products and click on the "copy" button. That will generate new products with the variants configured like the previous ones.

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0
11 years 2 months ago #125643

Yes I know how to create next month's product by copying a previous one it's the 200 imported from VM with no characteristics I'm asking about.
Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 83023
  • Thank you received: 13403
  • MODERATOR
11 years 2 months ago #125649

For that I don't have a solution. You'll have to do them one by one.

Please Log in or Create an account to join the conversation.

Time to create page: 0.101 seconds
Powered by Kunena Forum