super search price – Page 2

swiftideas

ATTENTION, PLEASE READ: New topic creation is disabled, as we have moved to a new support system. Your existing topics will remain, but for all new requests you will need to use the new system. Click here to go to the new support request form.

This topic has 23 replies, 4 voices, and was last updated 9 years by Rui Guerreiro – SUPPORT.

Viewing 9 posts - 16 through 24 (of 24 total)

← 1 2

Back to forum

Posted in: Neighborhood
February 4, 2015 at 4:06 pm #147256

Rui Guerreiro – SUPPORT
Keymaster

Post count: 25779

Hi geomatani,

Any news?
Thanks

-Rui

February 4, 2015 at 4:17 pm #147264

geomatani
Member

Post count: 129

I was going to look at the database.
Do you know what is the table name that stores product prices?

February 4, 2015 at 4:24 pm #147272

Rui Guerreiro – SUPPORT
Keymaster

Post count: 25779

The product prices are probably stored in postmeta table. The way WordPress stores information it’s a bit different than usual database design.

I just need to make a few select querys to check where that price is coming from.
Of course I won’t execute any query that changes the database info but you can make a backup first.

Thanks
-Rui

February 4, 2015 at 4:40 pm #147282

geomatani
Member

Post count: 129

This reply has been marked as private.

February 4, 2015 at 4:45 pm #147285

Rui Guerreiro – SUPPORT
Keymaster

Post count: 25779

Hi,

Can you provide us admin access again to check that product id?
-Rui

February 4, 2015 at 4:50 pm #147289

geomatani
Member

Post count: 129

This reply has been marked as private.

February 4, 2015 at 5:01 pm #147297

Rui Guerreiro – SUPPORT
Keymaster

Post count: 25779

The problem is due to inconsistent Wooocommerce data in the database.
Existed a product variation for a product that don’t exist anymore.

https://www.dropbox.com/s/0se1j9byvzc6vgc/product_variation_issue.png?dl=0

http://www.solbiatosport.net/wp-admin/edit.php?post_status=trash&post_type=product_variation

I just delete it and it’s in trash and now the Super Search max price is 810

-Rui

February 4, 2015 at 5:05 pm #147298

geomatani
Member

Post count: 129

This reply has been marked as private.

February 4, 2015 at 5:13 pm #147301

Rui Guerreiro – SUPPORT
Keymaster

Post count: 25779

No problem. Glad it’s sorted.
-Rui
Back to forum

Posted in: Neighborhood

Viewing 9 posts - 16 through 24 (of 24 total)

← 1 2

You must be logged in and have valid license to reply to this topic.

License required for one of the following items

ATTENTION, PLEASE READ: New topic creation is disabled, as we have moved to a new support system. Your existing topics will remain, but for all new requests you will need to use the new system. Click here to go to the new support request form.

Support Request

Support Policy

Privacy Policy