Reset All Magento 2 data, SQL Script?

Do you have a script that will reset our stores without having to create a new store and migrate our custom code, theme, etc.?
 
Back Story:
We have UB DATA Pro, picked it up a couple of days ago and well it seems to work well for s blank M2 instance. 
I’m not so sure it will work for us, we used the built-in migration tool awhile back and it did ok, just a real pain to get everything working correctly. 
SO we decided to not redo our M2 instance and grab an off the shelf tool reset our store and do a migration. 
It initially worked pretty well but we had an issue with our grouped products pages(showing not in stock, I think due to the store ID when we did the STORE MERGE step 2).
 
 
 
 
 

3 answers

Profile photo of ubdev Staff 98150.00 $tone March 19, 2019
Public

Hi there, 

It initially worked pretty well but we had an issue with our grouped products pages(showing not in stock, I think due to the store ID when we did the STORE MERGE step 2).

Since we have not enough information and your specific context, we could not give a more detailed comment at the moment.
For now, please check the stock data associated with the products you mentioned in the following tables:

cataloginventory_stock_item
cataloginventory_stock_status

Based on which you can see if the stock data has been migrated correctly as per your M1 database. Actually stock managment might have difference in the logic between Grouped Products in M1 vs. M2. This refers more to the Magento core.
Regards,
Ubertheme team

#1
Profile photo of wadeopgh 110.00 $tone March 21, 2019
Public

I figured out the issue with my grouped products…
 
In our M1 store we were not tracking inventory, when something was out of stock we would simply alter that one item to manage stock, no stock. 

In M2 it seems that it will not work this way for grouped products, SO I exported all products gave them a qty of 200, marked them as In Stock and reimported them. Next, I turned on Manage Inventory for my store, and now everything works great. 
I’m still testing the store post UB Migration but so far it’s working. 

#2
Profile photo of ubdev Staff 98150.00 $tone March 22, 2019
Public

Hi there, 
Glad that you figured it out at your end. Please move forward with the migration process at your end.
If you run across any issue, please let us know here, we will work closely with you then. 
Regards,
Ubertheme team

#3

Please login or Register to Submit Answer

Written By

Comments