Rank: Member
Joined: 1/19/2005(UTC)
Posts: 49
|
For some reason we have additional images showing up that we did not add to a product. Sometime they are blank images, and some times they are an image from another product. It is creating a problem on Google with the product feed. It's creating a image link like http://xxx.com/123.jpghttp://xxx.com/369.jpg.Is there a way to clear all of the additional images from the database other than going through each product one by one? |
Thanks Matt |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,381 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: toolsup  For some reason we have additional images showing up that we did not add to a product. Sometime they are blank images, and some times they are an image from another product. The wrong additional image(s) are probably happening when you clone one product to make another product. The blank images were probably created before you upgraded; this was a bug that was fixed in 2013. You will need to remove these from your products. Originally Posted by: toolsup Can you post a feed file with a few samples rows of bad data? Originally Posted by: toolsup Is there a way to clear all of the additional images from the database other than going through each product one by one? You could do this with a SQL query. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/19/2005(UTC)
Posts: 49
|
That's kind a funny. I downloaded and fixed the feed from Google and now the feed engine isn't generating a Google feed but he Bing feed is coming out fine.
What should the SQL query be?
|
Thanks Matt |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,381 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: toolsup I downloaded and fixed the feed from Google and now the feed engine isn't generating a Google feed but he Bing feed is coming out fine. We've identified a bug in the Google Shopping feed that causes it to fail on subsequent generations. The workaround for the time being is to restart the application (e.g. download/re-upload Web.config file). Originally Posted by: toolsup What should the SQL query be? If you want to delete all of the additional images in the database this is the query that you will need to run. As always, make a database backup before running a script like this that will purge so much data. Code:
DELETE
FROM bvc_ProductImage
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/19/2005(UTC)
Posts: 49
|
Thanks Aaron.
The feed tool did start working again.
How would we modify this to just delete the additional images? |
Thanks Matt |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,381 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: toolsup How would we modify this to just delete the additional images? That's what the query does. The small and medium images are stored in the main product table (bvc_Product). |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/19/2005(UTC)
Posts: 49
|
|
Thanks Matt |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.