ProductCart Shopping Cart Software Forums : Database import of items weighing under 1 oz https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 06:58:31 +0000 Tue, 25 Aug 2009 12:13:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2959 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Database import of items weighing under 1 oz : I ended up running the following...]]> https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11135.html#11135 Author: BrianRoden
Subject: 2959
Posted: 25-August-2009 at 12:13pm

I ended up running the following query after importing the new items:
 
update products
set pcprod_QtyToPound = floor(16 / (i.itemweight*16))
from products p inner join saleshist..laistdp i ON p.sku=i.ItemNum
where (i.itemweight * 16) < 1 and p.weight<=1
 
saleshist..laistdp is a table in another DB on our in-house SQL Server that has product weights and dimensions from our AS/400 warehouse system. We have the ProductCart database on our in-house SQL box, with merge replication to the web server. This lets our warehouse inventory update the local SQL Server nightly, which then replicates in the early a.m. hours to the storefront site.
]]> Tue, 25 Aug 2009 12:13:36 +0000 https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11135.html#11135 <![CDATA[Database import of items weighing under 1 oz : I have the same question as above....]]> https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11134.html#11134 Author: Carebear
Subject: 2959
Posted: 25-August-2009 at 11:36am

I have the same question as above. Anyone have an answer?]]> Tue, 25 Aug 2009 11:36:12 +0000 https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11134.html#11134 <![CDATA[Database import of items weighing under 1 oz : OK, I found the field pcprod_QtyToPound...]]> https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11035.html#11035 Author: BrianRoden
Subject: 2959
Posted: 18-August-2009 at 5:26pm

OK, I found the field pcprod_QtyToPound referenced in ModifyProduct.asp. But that's not a field that can be specified in the import file. Am I going to need to do an SSIS import job to a temp table that includes the fractional ounce weight, then run an update query like
 
UPDATE products
SET pcprod_QtyToPound=(16 / othertable.weight)
FROM products INNER JOIN othertable ON products.SKU=othertable.SKU
 
?
]]> Tue, 18 Aug 2009 17:26:52 +0000 https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11035.html#11035 <![CDATA[Database import of items weighing under 1 oz : We&#039;re getting ready to load...]]> https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11009.html#11009 Author: BrianRoden
Subject: 2959
Posted: 17-August-2009 at 10:54am

We're getting ready to load a bunch of new items to one of our ProductCart sites. These are scrapbooking papers that must be ordered in packs of 25 sheets. Our in-house system handles these as individual sheets sold in multiples of 25. So the weight is for 1 sheet, something like 0.48 ounces.
 
We want to load the items using a CSV file of data exported from our inventory system (with the other fields like main image and description filled in by us in the CSV file). However, we had an issue a couple of weeks ago with an item that was .8 ounces, that showed up in ProductCart as 0 ounces (we discovered this when we saw an order with no shipping charged, and it was due to the weight).
 
I know we can use the Control Panel item maintenance to set the weight for items by specifying how many units make up a pound. But we have over 100 SKUs that fall into this group of sub-ounce weights, and manually setting weights for all of them via the web interface will take a few hours.
 
Any advice?
]]> Mon, 17 Aug 2009 10:54:32 +0000 https://forum.productcart.com/database-import-of-items-weighing-under-1-oz_topic2959_post11009.html#11009