HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting products & default settingsImporting products & default settings
Previous
 
Next
New Post
6/27/2011 2:04 PM
 
Armando
No Ranking


Joined: 6/27/2011
Posts: 25

 I am bulk importing product data via XLS file, and cannot determine how to make a variant field (textbox) required. Can you tell me if there is a way to designate that in the spreadsheet? I am working on a deadline, and if this all works we’ll be purchasing your product today, tomorrow at the latest. also need to know how to set defaults for all products rather than one-by-one, as i don't see these in your spreadsheet template either. For example, "tax exempt," "include handling," "recurring billing - monthly, recurrences, etc. will all be the same for every product. So how do I set that in XLS file, or how do I make what I want a default for all products? Thanks.
 
New Post
6/27/2011 2:56 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Armando,

Currently the Variant Required field.is not one of the available fields in the product import spec.  Here is a link to the product import spec with a sample xls for your reference:

http://www.smith-consulting.com/Forum...

As an alternative, if you want to update all your variants as required after you import them in the cart you can issue the following SQL statement in SSMS:

update smith_productvariants set variantrequired=1

We can add the Variant Required field to the import spec if you would like it should be pretty easy to program, let me know and I can provide you a quote it should only take a day to add it.


Thanks
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting products & default settingsImporting products & default settings




Questions? Contact us for answers!

Contact Us!