an ASP.NET Open Source CMS & eCommerce platform
Search:
Last Post 12/5/2016 2:03:42 AM By kaylee. 13 replies.
Page 1 of 2 (14 posts) << First < Prev 1 2 Next > Last >> 
1/20/2009 12:58:41 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Images in Bulk Product
Hi,
 
Can I Import my products without image and then another time Import with images strings, Does the bulk import poulates the images for the existing products.
 
Bahram
1/20/2009 2:01:46 PM
lukezy
Posts: 2110
Joined: 6/12/2007
Location:WA, US
Re: Images in Bulk Product
Yes, you can import products without images. If you want to bulk import to overwrite the existing products, make sure you pass in the same SKU which is used to unqiue identify the products.
DotShoppingCart Staff
1/21/2009 9:41:33 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Images in Bulk Product
And does this time we have an Image only update also at a third time we would have more images , do we have just new image added to the system.  
1/21/2009 10:05:15 AM
lukezy
Posts: 2110
Joined: 6/12/2007
Location:WA, US
Re: Images in Bulk Product
No, you cannot do just image only update. You have to populate other fields as well. The software cannot know if you want to clear other fields or skip other fields.
DotShoppingCart Staff
1/22/2009 10:38:57 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Images in Bulk Product
 
This my scenarios :
 
1 - What I mean of Image Only is from my view. Actually I provide and regenerate the whole text file with latest data. Quantity, Price are changed. Some new Image strings are added. some Products with no Image befor, have new Images. Does this work as expected.
 
Bahram
1/22/2009 11:14:39 AM
lukezy
Posts: 2110
Joined: 6/12/2007
Location:WA, US
Re: Images in Bulk Product
Yes, it should work. Make sure you have SKU unchanged.
DotShoppingCart Staff
1/22/2009 12:26:47 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Images in Bulk Product
-
1/22/2009 1:49:40 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Sort Order in Bulk Product
How we can have our own sort order on bulk import
1/22/2009 2:17:01 PM
lukezy
Posts: 2110
Joined: 6/12/2007
Location:WA, US
Re: Images in Bulk Product
If it's defined in the current bulk import format, then it's not supported now. You either have to write your own tool to do the import or wait until the next version to implement xml based bulk import format.
DotShoppingCart Staff
2/10/2011 6:52:45 PM
malshini
Posts: 29
Joined: 11/9/2010
Re: Images in Bulk Product
When we delete an image of a product, shouldn't the record in DSC_Image table be deleted? Currently, it is adding up, and the database storgae has increased tremendously.
 
Please give me a solution. Also, if i remove the old data, will it affect the images in themes or logos ?
 
Does DSC_Image table store images of products ONLY?
 
Thanks a lot!
2/10/2011 8:34:25 PM
lukezy
Posts: 2110
Joined: 6/12/2007
Location:WA, US
Re: Images in Bulk Product
You can use the following SQL script to clean up unused images.
 
delete from DSC_Image
where imageId not in (select imageId from dbo.DSC_Product_Image_Map)
and imageId not in (select imageId from dbo.DSC_Manufacturer where imageId is not null)
and imageId not in (select imageId from dbo.DSC_Product_Attribute_Value where imageId is not null)
DotShoppingCart Staff
Page 1 of 2 (14 posts) << First < Prev 1 2 Next > Last >>