DATABASE additional shipping cost reading

PrestaShop / PrestaShop

PrestaShop is the universal open-source software platform to build your e-commerce solution.

https://www.prestashop-project.org/

Other

8.23k stars 4.81k forks source link

Closed matteolavaggi closed 5 years ago

matteolavaggi commented 5 years ago

This is (another) one crazy situation with prestashop 1.7.2.

Create a product. assign a 10€ value for extra shipping cost.

Open in database that product, Set shipping cost to 0€ extra.

Reload cart > still get the extra 10€.

Open product in backoffice, still 10€ in extra shipping cost.

Reload product in DB, the shipping cost save in the ps_products tab is 0.

So WHERE prestashop get this data?!

Mysql query is cleared .. and this is crazy. HOW THIS IS POSSIBLE WHERE PS READ THE DATA

Matt75 commented 5 years ago

Check into ps_product_shop

matteolavaggi commented 5 years ago

Why? There is no index for products in category but there is 2 table for the same setting , i would cry.