ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Dropshipper is broken.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Dropshipper is broken.
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
Brett View Drop Down
Groupie
Groupie
Avatar

Joined: 22-April-2008
Location: Phoenix, AZ
Status: Offline
Points: 89 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Brett Quote  Post ReplyReply Direct Link To This Post Topic: Dropshipper is broken.
    Posted: 05-July-2012 at 8:08pm
I used global change to set dropshipper on a bunch of products.

Then it turned out we can't ship those manually if we have a dropshipper set, so I had to set all those products to not be drop shipped using another global change.

Unfortunately, although it has set them not to be drop shipped, it has not cleared the drop shipper.

Now I can't ship anything and I have to dig into the database to fix it. Yay!
Back to Top
Brett View Drop Down
Groupie
Groupie
Avatar

Joined: 22-April-2008
Location: Phoenix, AZ
Status: Offline
Points: 89 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Brett Quote  Post ReplyReply Direct Link To This Post Posted: 05-July-2012 at 8:16pm
Had to run these queries on products and ProductsOrdered:


update ProductsOrdered set pcDropShipper_ID=0 where pcDropShipper_ID=12;
update products set pcDropShipper_ID=0 where pcDropShipper_ID=12;


As usual I'm sure this "was patched" and I just need to upgrade lol.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.