TamasFelix Posted October 22 Share Posted October 22 Hello, I have an online store Fashionland.ro prestashop 8.1.4 I have a problem with the product stock quantity, for one product I deleted the attribute of one size and I had 6 pieces, and I added another attribute instead of size S which has 6 pieces. Why does it show me 12 pieces? and in the database it doubled? Where can I find in the database that line to remove the stock at the old attribute? ( I am also attaching a picture ) Link to comment Share on other sites More sharing options...
Divine Posted October 22 Share Posted October 22 Hello, You can do this in your back-office from the section "Catalog >> Stock". Link to comment Share on other sites More sharing options...
Knowband Plugins Posted October 23 Share Posted October 23 Hi, To avoid such issues in the future, it’s important to follow these practices when deleting and adding attributes: Sync stock manually using the "Stock" menu in the back office to ensure accurate stock levels are maintained after modifying combinations. By removing the old stock entry from ps_stock_available and ensuring the old attribute combination is fully deleted, you should be able to fix the issue. Regards. Link to comment Share on other sites More sharing options...
TamasFelix Posted October 23 Author Share Posted October 23 Hello Knowband Plugins, Thanks! I found that stock in ps_stock_available, but my question is, where can I find the table where my stock is left, the difference to the attribute that I deleted? Thanks! Felix FashionLand S.R.L, BaiaMare, Bld. Regele Mihai I, nr. 55, TEL: 0745024045 Link to comment Share on other sites More sharing options...
TamasFelix Posted October 23 Author Share Posted October 23 Hello, In which table can I find the stock for each product? Link to comment Share on other sites More sharing options...
Divine Posted October 23 Share Posted October 23 Il y a 23 heures, Divine a dit : Hello, You can do this in your back-office from the section "Catalog >> Stock". Link to comment Share on other sites More sharing options...
TamasFelix Posted October 24 Author Share Posted October 24 Hello Divine, I don't know if I was understood I am interested in why there is that difference in products from the Catalog >> Stock, there are 5 pieces and under Products>> I see 11 pices I'm interested in where I can find differences in the database to set to zero. I mention, everything happened because I removed an S attribute and added another One SIze attribute, somewhere in the database the attribute S that I deleted has stock. I want the real stock to appear in the white parts Link to comment Share on other sites More sharing options...
Divine Posted October 24 Share Posted October 24 Oh sorry I didn't understand that. So you can check the tables that begin with "[dbprefix]_stock" in the database. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now