Copying Products from One category to another

  • Posts: 34
  • Thank you received: 0
12 years 10 months ago #44111

Hello,

Great product you have here. I have purchased the business version but have a question. The way my business works is I run a show and sell advertising slots for each part of the show. The slots are the product as far as Hikashop is concerned. I create a category for each show and have the products (or ad slots for sale) in the category. Since every show has the same slots for sale I am looking for a quick way to set up new categories and copy the products to the new category. The copy function seems to copy the products into the same category which does not work for me. I run 4-5 shows a week and need a way to quickly set up these shows using the already configured products. The reason I do it like this is so I can easily update my "Upcoming Events" module on the front page and each link is the date and name of the show and links directly to the shop. This way my clients can see the upcoming shows, click the link and be taken to the shop for that specific show then purchase the desired slots.

Any ideas?

Last edit: 12 years 10 months ago by BarBomb.

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

  • Posts: 34
  • Thank you received: 0
12 years 10 months ago #44171

OR is it possible to have a recurring shop. Below is an example of the functionality I am looking for:


Upcoming Events Module (Custom HTML)

________________________________________
|
Bar XYZ 4.21.12 <--- link to store |
Bar ABC 4.27.12 <--- link to store |
Lounge 123 4.30.12 <-- link to store |
|
________________________________________|


Each store has the same exact products (advertising slots) as all the others. I just need a way to mass copy the products from one category to another as the links in the module link to an entire category. Perhaps this explains my needs better than my above post. Maybe I am going about things the wrong way.

I hope I hear back from someone soon as my issue is a tad time sensitive at this point and I am a paying for support.

Thank you

Last edit: 12 years 10 months ago by BarBomb.

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

  • Posts: 83103
  • Thank you received: 13418
  • MODERATOR
12 years 10 months ago #44263

Hi,

There is no option to mass copy products from one category to another.
You can mass duplicate them by selecting all of them in the products listing and clicking on "copy".
Then, if you want to move lots of products from one category to another rapidly, the fastest is to run a MySQL query in your database via phpmyadmin.

For example, if you just mass duplicated all your products in the category with the id 15, and that all the copies have at least the product id 236, and that you want to move them to the category with the id 62, you can run that query:

UPDATE jos_hikashop_product_category SET category_id = 62 WEHRE category_id = 15 AND product_id > 236;

That will move all the duplicates instantaneously.

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

  • Posts: 34
  • Thank you received: 0
12 years 10 months ago #44322

Ok interesting. I will try that. Is there a better way to do what I am trying to do though? Perhaps I am using this very good system incorrectly?

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

  • Posts: 83103
  • Thank you received: 13418
  • MODERATOR
12 years 9 months ago #44515

Not for now, We are currently working on HikaSerial, an extension of HikaShop which will handle "slots" for your products. So that should help you avoid to duplicate all your products by having only one product to duplicate each time and then associating it with "slots".

If you're interested to know more about that, you can contact my colleague : jerome at hikashop dot com

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

  • Posts: 34
  • Thank you received: 0
12 years 9 months ago #44530

I emailed him regarding this. Thank you.

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

Time to create page: 0.041 seconds
Powered by Kunena Forum