I know you say it's not a bug but.......

[Bside2234]

I've done 3 fresh installs of TB now and I'm getting the same result every time. This last time I did it in a brand new folder and checked install the demo stuff. The ONLY thing I've done is change the stock on one candle combo to 0 and it messes all the stock up just like I've been saying.

Am I doing something wrong? I've been using Prestashop since 1.4 and run/maintain the shop myself so I kind of know what I'm doing but maybe there is something/some setting in TB that I need to change?

Here is the Demo/Test shop product I changed the stock quantity: http://griffineffects.com/shop/gifts/candle#/1-size-12_oz/22-scent-honey

The pic below shows I just changed the quantity of Candle-Size-12oz. Scent - Honey to 0

The below picture shows 12oz Honey has a quantity of 1799 (quantity is mixed up with 24oz/Puffin) and should be 0 and the Add to cart button is shown.

Now the below picture shows 12oz/Puffin has 0 quantity and the Add to cart button is gone. This is mixed up with 12oz/Honey.

So all the quantities are mixed up.

Honey/12oz shows 1799 items when it should be 0
Honey/16oz shows 899 items when it should be 900
Honey/24oz shows 3600 items when it should be 900
Puffin/12oz shows 0 items when it should be 899
Puffin/16oz shows 900 items when it should be 3600
Puffin/24oz shows 900 items when it should be 1799

I've now done this 4 time total (1 with my own products and 3 with the demo products). Brand new database ever time. I've use Filezilla 2 times and by CPanel 2 times to upload the files. Same result every time.

If this isn't a bug, what is going on? Brand new store. Nothing change but one quantity to 0 on demo item and stock gets all messed up.
 

[Bside2234]

Now looking at the database for this product: https://griffineffects.com/parts/potentiometers-trimmers/16mm-long-leg-solid-shaft

This product has 2 combinations. 100K Log (A) which has a quantity of 1 and 500K Log (A) which has a quantity of 5. This is correct on the front office/store thanks to Store Manager but they are showing swapped still in the stores backoffice.

The database table under tb_products for this product a quantity of 8. Shouldn't it show 6? I'm thinking maybe this column is showing the original combination quantity I entered when creating the product because I entered 1 and 7 as quantity originally.

I'm not seeing any column in tb_product_shop that is referencing any stock quantities but I'm comparing the columns with the two products that have the correct quantities shown in the front end to see if there are any differences and there aren't that I see.

I honestly don't really know what I'm look at/for in tb_stock_available or really what most of the numbers mean. I found rows (shown below) with a product id of 163 (which is the product id of the product linked above). I don't know how to tell if the 1 and 5 are mixed up here or not. Also, all the product have that row with 0 id_product_attribute and the quantity column which seems to show a total quantity. Is this correct that it's supposed to be like this?

	id_stock_available	id_product	id_product_attribute	id_shop	id_shop_group	quantity	depends_on_stock	out_of_stock
		
		3567 	            162 	         0 	           1 	      0 	       90 	            0 	             1
		3570 	            162 	       3408 	           1 	      0 	       25 	            0 	             1
		3572 	            162 	       3410 	           1 	      0 	       25 	            0 	             1
		3573 	            162 	       3411 	           1 	      0 	       16 	            0 	             1
		3575 	            162 	       3413 	           1 	      0 	       24 	            0 	             1
		3577 	            163 	        0 	           1 	      0 	        6 	            0                2
		3584 	            163 	       3421 	           1 	      0 	        1 	            0 	             2
		3585 	            163 	       3422 	           1 	      0 	        5 	            0 	             2

 

Edited August 28, 2021 by Bside2234

[musicmaster]

A trick that might help is comparing database exports. 

 - Export a shop database.

 - change a quantity in the backoffice

 - export the database again

 - compare the two exports with a program like Winmerge.

 - now do the same when changing a quantity in Store Manager

[Bside2234]

2 hours ago, musicmaster said:

A trick that might help is comparing database exports. 

 - Export a shop database.

 - change a quantity in the backoffice

 - export the database again

 - compare the two exports with a program like Winmerge.

 - now do the same when changing a quantity in Store Manager

Good idea. Thanks.

[Bside2234]

Starting to compare databases. I'm going to post what I find here in two replies to keep it separate.

So this is what this is as suggested:

" - Export a shop database.

 - change a quantity in the backoffice

 - export the database again

 - compare the two exports"

I'm sticking with changing the same product https://griffineffects.com/parts/potentiometers-trimmers/16mm-long-leg-solid-shaft since there are only two combinations to keep it simple. This product has a ID of 163.

These first differences are with changes from Database A (This is the database I started with for this comparison with 163 quantity in Store Manager which shows correct in front end but quantity is swapped in TB back office) to Database B (I swapped the quantities in the TB back office).

Database A (Original store manager database that shows correct in store but mixed in TB back office) is on the left of the pics. Database B (Swapped 1 and 5 quantities for product 163 in TB back office which shows stock mixed up in store) is on the right in the pics

Dumping data file for table tb_log

Dumping data for table tb_product_shop

Dumping date for table tb_product Dumping data for table tb_product_tag

Dumping data for table tb_product_tag

Dumping data for table tb_stock_available

Dumping data for table tb_tag

Dumping data or table tb_tag

Edited August 30, 2021 by Bside2234

[Bside2234]

So now I did this:  - now do the same when changing a quantity in Store Manager

There were a lot less differences this time. I'm not sure what to make of that.

So in the tables below...The left side is Database B (the TB back office stock changed database) while on the right is Database A (where I swapped the stock back using Store Manager)

Dumping data for table tb_product Dumping data for table tb_stock_available

 

Edited August 30, 2021 by Bside2234

[Bside2234]

That Alter table thing kind of stood out to me and I didn't remember it in the first compare so I went back and looked to see if I missed it.

This first image is changing the stock in the backoffice which leads to the wrong quantities showing up in the store.

This next image is when I change the stock in Store Manager which leads to the correct quantities showing up in the store.

Both ways still do show the quantities in the backoffice wrong/swapped but for some reason changing them in Store Manager makes them show up in the store correctly.

I'm kind of leaning towards this isn't a database issue and maybe a issue with the the backoffice and creating the combinations.

I have one thing left to try and that's to create a new product with combinations in Store Manager to see how it shows up in the store and in the TB back office.

Edited August 30, 2021 by Bside2234

[musicmaster]

I don't see anything suspicious that could explain anything. But I am puzzled by the tags, the initially empty redirect field in the ps_product_shop table and by the Alter Table command. It looks like more is happening than you tell.

56 minutes ago, Bside2234 said:

Both ways still do show the quantities in the backoffice wrong/swapped

That "wrong/swapped" is a kind of fuzzy language that doesn't help.

[Bside2234]

4 hours ago, musicmaster said:

I don't see anything suspicious that could explain anything. But I am puzzled by the tags, the initially empty redirect field in the ps_product_shop table and by the Alter Table command. It looks like more is happening than you tell.

That "wrong/swapped" is a kind of fuzzy language that doesn't help.

I wasn't sure if the tags tables meant anything. I just posted any differences that had to do with product 163 that I could find. The tb_product_shop has the missing 404 when the two combination quantities are changed using the TB back office. It's there when I use Store Manager to alter the quantities. The alter table thing is suspicious to me but I really don't 100% understand what it is/does.

I don't know what you mean by " It looks like more is happening than you tell." I'm trying to explain everything and show everything related to this product that has changed between the two database comparisons. I don't know what else to tell you. It happens on both a fresh install with demo products and my live store.

"That "wrong/swapped" is a kind of fuzzy language that doesn't help." Sorry. I can't think of better terminology. I'm literally changing/swapping the stock quantity from 1 to 5 and 5 to 1 of product 163 for the database comparisons. The quantities are showing "wrong/swapped" (quantity 5 is showing for 100K attribute and quantity 1 is showing for 500K attribute. It should be the other way around as shown here

) in the TB back office stock quantity fields. If you have better, clearer terminology, let me know and I'll gladly use it.

[musicmaster]

The Alter Table command tells me that two records have been added to this table. But I don't see those added records in your list.

The "wrong/swapped" issue is only becoming fuzzier to me. What is the problem? Do you have wrong values for quantities or are they only swapped between variants?

[Bside2234]

6 hours ago, musicmaster said:

The "wrong/swapped" issue is only becoming fuzzier to me. What is the problem? Do you have wrong values for quantities or are they only swapped between variants?

It's hard to explain clearly.

Say I create a product with two combinations. We'll call these combinations Combo 1 with a quantity of 1 and Combo 2 with a quantity of 2.

If I create this product using the TB back office Combo 1 shows up in the store with a quantity of 2 and Combo 2 shows up in the store with a quantity of 1. 

I can correct the quantities in the storefront by swapping the quantities. Combo 1 to quantity 2 and Combo 2 to quantity 1. This makes it show up correctly in the storefront. So I have to swap the quantities in the back office to make the show up correctly in the storefront.

 

I have Store Manager right now and if I use SM to update or change the quantities...Say I change Combo 1 to 100 and Combo 2 to 200 using store manager, the quantities in the store front end show correctly. Combo 1 is 100 and Combo 2 is 200.

So entering the correct quantities for the correct combination using Store Manager actually shows the correct quantities in the storefront BUT it does "write" the quantities in the TB back office as Combo 1 having 200 and Combo 2 having a quantity of 100.

 

This gets more complicated when a product has, say, 4 combinations. I did try and explain all this with pictures in my previous posts. See pics below:

Test Product - Value 1 with a quantity of 1 shows up in the storefront with a quantity of 4. Each quantity is shifted down and the last quantity is moved to the top.

So with the quantities as shown in the pictures below...

Value 1 has a quantity of 4 in the storefront
Value 2 has a quantity of 1 in the storefront
Value 3 has a quantity of 2 in the storefront
Value 4 has a quantity of 3 in the storefront

      

My theory is there is something in TB not writing things properly to the database. I think Store Manager is linked directly to the database and makes changes directly to it and it's writing things correctly to the database.

If I use Store Manager to set the quantities

Value 1 - quantity 1
Value 2 - quantity 2
Value 3 - quantity 3
Value 4 - quantity 4

The quantities show up correct in the store front.

When I go into the TB back office and look at this products quantities it shows:

Value 1 - quantity 4
Value 2 - quantity 1
Value 3 - quantity 2
Value 4 - quantity 3

So Store Manager seems to be writing the correct quantities to the database.

 

[musicmaster]

44 minutes ago, Bside2234 said:

BUT it does "write" the quantities in the TB back office as Combo 1 having 200 and Combo 2 having a quantity of 100.

This is starting to sound like you have a problem with the naming that leads to confusion.

[Bside2234]

6 minutes ago, musicmaster said:

This is starting to sound like you have a problem with the naming that leads to confusion.

I'm sorry. I don't know how else to put things. I'm trying to explain things the best I can. If you have suggestions in terms of what I should be calling things, let me know. What do you call it when you create a product in TB and it writes/adds/sends/etc. info into the database. I'm not a tech guy in this industry so I guess I don't know the proper terminology. Kind of why I put quotes on it.

Can you not see the problem from the pictures though? Regardless of what I call things? I think it should be pretty obvious the stock quantities are wrong.

I guess I'll just purchase Store Manager so I can at least get the quantities to show up correctly in the store. Kind of would have been nice to fix it and not spend hundreds of dollars to just be able to enter stock quantities.

[musicmaster]

56 minutes ago, Bside2234 said:

I'm sorry. I don't know how else to put things. I'm trying to explain things the best I can. If you have suggestions in terms of what I should be calling things, let me know. What do you call it when you create a product in TB and it writes/adds/sends/etc. info into the database. I'm not a tech guy in this industry so I guess I don't know the proper terminology. Kind of why I put quotes on it.

Can you not see the problem from the pictures though? Regardless of what I call things? I think it should be pretty obvious the stock quantities are wrong.

I guess I'll just purchase Store Manager so I can at least get the quantities to show up correctly in the store. Kind of would have been nice to fix it and not spend hundreds of dollars to just be able to enter stock quantities.

Did you try what happens when you set quantities with Prestools?

[Bside2234]

49 minutes ago, musicmaster said:

Did you try what happens when you set quantities with Prestools?

No, I haven't tried Prestools yet. I'll give it a try and see what happens.

I get the same results with Prestools as I do with Store Manager. Entering the quantities in these two tools/apps results in proper quantities showing in the store and in the database. The quantities are shown flipped in the TB backoffice. It looks to me there is something wrong with TB as external database editors are working fine and showing the quantities correctly in them but not in the TB back office.

Edited August 31, 2021 by Bside2234

[Bside2234]

I just wanted to add this to here....

I've been getting by dealing with this using the eMagicOne store manager. It's the only way I could keep my head around inventory.

I've tried the bleeding edge and the stable version with the same inventory mix up result.

I just updated to 1.3.0 and now my inventory miraculously is fine. It's showing the proper quantities in both the store AND in the back office. We'll see how long this lasts.