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
What Table Holds the Product Options Data?
-
- Lieutenant, Jr. Grade (LT JG)
- Posts: 45
- Joined: Wed May 25, 2016 3:32 am
Re: What Table Holds the Product Options Data?
You need to look into ac_OptionChoices table. Every product option can have multiple choices which may have different price, weights.