What Table Holds the Product Options Data?

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
skinsfan99
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Wed May 25, 2016 3:32 am

What Table Holds the Product Options Data?

Post by skinsfan99 » Thu Dec 08, 2016 9:23 am

Hello,

I am trying to pull data for a report and am having trouble locating the table/field that holds the option choices data on the options tab.

I tried ac_ProductOptions and ac_ProductVariants but they don't seem to have what I looking for.

I am specifically looking for the option name, price, retail, weight and sku.

If you need a product to look at use ETS for Humans.

Katie has a login to our store.

Thanks,
David

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: What Table Holds the Product Options Data?

Post by mazhar » Thu Dec 08, 2016 11:09 pm

You need to look into ac_OptionChoices table. Every product option can have multiple choices which may have different price, weights.

Post Reply