My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

  #1  
Old 12-Apr-2012, 08:18 AM
johngwms's Avatar
johngwms johngwms is offline
Registered User
Join Date: Oct 2007
Full Name: John Legg
Posts: 197
Thanks: 35
Thanked 4 Times in 4 Posts
Sitewide Changes to Custom Variables

I need to update the content of custom variables used on my product pages so I can update the requirements of the Amazon product feed.

If I had a new to do that would be easy. I have over 1000 products and I need to find a faster way of updating them. I have looked at the Access files but it seems making global changes there is not practical and the variables are not included in the Products Table. It looks as if they are stored in the Variables Table and by reference only.

Any ideas guys?
Reply With Quote
  #2  
Old 12-Apr-2012, 08:38 AM
leehack's Avatar
leehack leehack is offline
Moderator
Join Date: Nov 2005
Full Name: Lee Hackett
Posts: 15,179
Thanks: 219
Thanked 482 Times in 423 Posts
Hierarchical export, they're included on that.
Reply With Quote
  #3  
Old 12-Apr-2012, 09:48 AM
johngwms's Avatar
johngwms johngwms is offline
Registered User
Join Date: Oct 2007
Full Name: John Legg
Posts: 197
Thanks: 35
Thanked 4 Times in 4 Posts
Thanks Lee.

I do not see how I can edit this file in the way I need.

I can open it in Excel but need to re-arrange the products/sections to do the editing. This will destroy the structure of the file won't it?

Maybe I have missed the point?

John
Reply With Quote
  #4  
Old 12-Apr-2012, 09:57 AM
Duncan Rounding's Avatar
Duncan Rounding Duncan Rounding is offline
Administrator
Join Date: Sep 2005
Full Name: Duncan Rounding
Posts: 10,085
Thanks: 72
Thanked 405 Times in 374 Posts
Add a new temporary column on the very left side and enter a running number all the way down. That will allow you to play around in Excel as you want and then later re-order the rows again to suit. When you've finished delete the column and import.
__________________
SellerDeck/Actinic Report Modifications - Add your logo to your invoice - email for information
Integrated e-Commerce Web Design
SellerDeck/Actinic Upgrades, Custom Designs, Layout Modifications and General SellerDeck/Actinic Help
Reply With Quote
The Following User Says Thank You to Duncan Rounding For This Useful Post:
johngwms (12-Apr-2012)
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 03:42 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.