Rank: Member
Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL
Thanks: 64 times
|
I see that I can product batch update Gift Wrap Allowed - Yes or No. But where do I product batch update the Gift Wrap Charged amount? I have about 200 products in a specific Product Type that I need to change the price from $15 to $25. I can't use the site-wide Gift Wrap feature since this only pertains to a certain Product Type. And the site-wide feature will not override the product gift wrap feature. TKatch attached the following image(s):  Gift-Wrap.gif (23kb) downloaded 2 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Use the import/export tool |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
 1 user thanked Aaron for this useful post.
|
|
|
|
Rank: Member
Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL
Thanks: 64 times
|
Okay, good idea. I've never used the import/export feature. So, if I filter and Export the items needed, it creates a .txt file. I can then open it with Excel and make my edits easily enough. I tested it out with one item only so that I didn't break everything at once if I did something wrong. I saved the Excel file as a .txt file Imported it back to the website. Seemed to work so I did it with all of the filtered products. The import/export feature is very helpful! Edited by user Thursday, October 10, 2019 10:53:19 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: TKatch  I've never used the import/export feature. Come on! This is one of the best features we've added to BVC over the years. It's very powerful once you get the hang of it and manipulating data in Excel. One of our marketing guys is a Jedi with these tools. Originally Posted by: TKatch So, if I filter and Export the items needed, it creates a .txt file. I can then open it with Excel and make my edits easily enough. Correct. You can also use Excel to further filter the file. Just to sure to save out to a tab-delimited text file when you're done--Excel always wants you to save to an Excel format (i.e. .xls/.xlsx). One Excel issue to watch out for is that it will strip leading zeroes on fields that it interprets as numbers. Where this is most problematic is with UPCs and MPNs. To prevent Excel from doing this you should start with a blank Excel doc and import the export file into, specifying each field as a text field (which prevents Excel from messing with the data). Originally Posted by: TKatch I tested it out with one item only so that I didn't break everything at once if I did something wrong. I saved the Excel file as a .txt file Imported it back to the website. Smart! We are pretty stringent in validating the data coming in through the import, but obviously things can still go sideways depending what the user does. :) Originally Posted by: TKatch Seemed to work so I did it with all of the filtered products. The import/export feature is very helpful! Awesome! |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
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.