Post by Peter Dooley » Fri Jul 12, 2019 12:25 pm

I am using oc3 and need to add a global product option to an existing set op products. Can anyone tell me how to do this

Regards
Peter

New member

Posts

Joined
Fri Apr 05, 2019 2:40 pm

Post by cedcommerceteam » Fri Jul 12, 2019 5:08 pm

Hello Peter,

By Global Product Option, you mean all the common existing product options?
Kindly brief a l'll bit. Options will depend upon which kind of product you are using like for clothes mandatory options are size & color but if you are selling electronic goods then color, size may or may not be required but there must be some other options which are mandatory, so it totally depends upon your products.

Please explain your query so that we can help you in resolving your issue.

Thanks & Regards :

Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com
Webinar : Power up Your holiday season marketing with the Automation tool


User avatar
Active Member

Posts

Joined
Wed Aug 09, 2017 9:02 pm

Post by paulfeakins » Fri Jul 12, 2019 6:42 pm

Peter Dooley wrote:
Fri Jul 12, 2019 12:25 pm
I am using oc3 and need to add a global product option to an existing set op products. Can anyone tell me how to do this
Sounds like someone would need to write a script to add these in, you could ask in Commercial Support.

Do you know enough about the database to find the option in there?

Is it all products from a certain category?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by Peter Dooley » Fri Jul 12, 2019 9:35 pm

Sorry let me try to explain better.
I have 360 products existing in a category and now I want to add an extra purchase option to the existing size option.
These are all existing art prints on paper but I now want to add a canvas option too. So I need to add a radio button option to every existing product to allow the customer to choose between either paper prints or canvas prints but I do not want to add each option manually if I can help it.

The existing size option must obviously remain as it applies to the print size irrespective of it being on paper or canvas

I hope that makes more sense and thank you for your prompt responses

New member

Posts

Joined
Fri Apr 05, 2019 2:40 pm

Post by paulfeakins » Fri Jul 12, 2019 9:47 pm

So create the new option and apply it to one product.

Then look at the database to understand what has been added, likely a row will have been added to a table called product_option.

This will map all the options to any given product with its columns; product_id and option_id

You'll need to create new rows for every product with the option_id of your new option and the product_id of each product.

If none of that made any sense, ask a developer such as ourselves to quote.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by Peter Dooley » Sat Jul 13, 2019 1:24 am

Thanks Paul. Will take a look.

New member

Posts

Joined
Fri Apr 05, 2019 2:40 pm

Post by cedcommerceteam » Sat Jul 13, 2019 12:25 pm

Hello Peter,

I would like to continue what Mr. Paul has said, after you will manually enter option's option_id into product_option table then you need to fill option values for particular product in product_option_value table for this you need product_option_id(which you will get from product_option table ) , product_id, option_id, option_value_id, quantity, price & so on

So for this you need a developer who can write a query for you.

If you need any further help do write us here.

Thanks & Regards :

Call us at : (+91) -8765210318 , Skype: live:carlmorgan.cedcommerce , Email: support@cedcommerce.com
CedCommerece : Officail Opencart Partners
CedCommerce Official : www.cedcommerce.com
Opencart Services : www.cedcommerce/opencart-services.com
Sell On various Marketplace Integration : Opencart-Extensions
Magenative Mobile App/IOS Development : magenative.com
Webinar : Power up Your holiday season marketing with the Automation tool


User avatar
Active Member

Posts

Joined
Wed Aug 09, 2017 9:02 pm
Who is online

Users browsing this forum: ianhaney50 and 14 guests