Locstock Table Swap

[waddye]

Unfortunately when I started using weberp I loaded the products before creating the product locations so I am unable to transfer products to some locations. I created a locstock2 table that has all of the stockid and locations necessary.

What would be the recommended process for making locstock2 table the new locstock table? For example, should I change the primary keys first and then Drop locstock and rename locstock2 to locstock? Are there any other dependencies that I should consider?

[phil]

The interface creates locstock records as necessary. If you import items (which might result in no locstock record being created) you can recreate the necessary locstock records with Z_MakeStockLocns.php
I suggest ditch the new locstock2 and run the above script to create the records you need.

[waddye]

Thanks Phil! Next time I'll ask first before playing around with the tables.