Using ProductCart - Dropshipper is broken.

Print Page | Close Window

Dropshipper is broken.

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5204
Printed Date: 09-March-2025 at 5:53pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Dropshipper is broken.

Posted By: Brett
Subject: Dropshipper is broken.
Date 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!

Replies:

Posted By: Brett
Date 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.