Price information is not fetched

woocommerce / woocommerce-product-tables-feature-plugin

Implements new data-stores and moves product data into custom tables, with a new, normalised data structure.

GNU General Public License v3.0

193 stars 32 forks source link

Price information is not fetched #120

Open javorszky opened 6 years ago

javorszky commented 6 years ago

I've migrated the data. The table has the information about the price in the table: screen shot 2018-07-30 at 22 54 55

And yet

javorszky commented 6 years ago

I put some logging in the get_from_product_table method to see what information is being fetched from the table, and it's:

2018-07-31T00:11:51+00:00 INFO getting virtual
2018-07-31T00:11:51+00:00 INFO getting downloadable
2018-07-31T00:11:51+00:00 INFO getting tax_status
2018-07-31T00:11:51+00:00 INFO getting tax_class
2018-07-31T00:11:51+00:00 INFO getting stock_status

Note that prices are NOT in there.

rodrigoprimo commented 6 years ago

I'm not able to reproduce this. Product prices are displayed correctly for me in the product admin page. @kloon, did you try to reproduce it before labeling?

I put some logging in the get_from_product_table method to see what information is being fetched

Price is not fetched by get_from_product_table(), it is fetched by WC_Product_Data_Store_Custom_Table::get_product_row_from_db():

https://github.com/woocommerce/woocommerce-product-tables-feature-plugin/blob/1b0111dc013a82ea365ec52bdef1623ef7b755b2/includes/data-stores/class-wc-product-data-store-custom-table.php#L236

wss-chadical commented 5 years ago

Something to do with currency type? Euro vs $?

claudiosanches commented 5 years ago

@wss-chadical still should be able to fetch that information, since we don't save currency with the price in the database.