Using ProductCart - importing products into PC question

Print Page | Close Window

importing products into PC question

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5490
Printed Date: 10-March-2025 at 8:10am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: importing products into PC question

Posted By: Chris Hadden
Subject: importing products into PC question
Date Posted: 08-February-2013 at 3:18pm

In the .csv file I export from PC. nthat helps guide me add products. Some columns are unused ( blank ) I have been just deleting those before reimport.....some columns contain a 0 some a -1. Does the 0 indicate a particular setting? What if I delete those columns? Will the new product simply be assigned a 0?

Thanks

-------------
Chris

Replies:

Posted By: Guests
Date Posted: 09-February-2013 at 2:09am

Hi Chris,

I think some of this came over from Access a long time ago and is still legacy in the application.

Zero still means "off"/"not set", but in some cases "on"/"set" is represented with either a -1 or a 1.

There are a lot of these, and I can't say that most of them are set to have a "0" as the default in the database rather than a NULL (if you were to not include these columns in your spreadsheet).

However, I do not think NULL rather than "0" is an issue anywhere in the application. That's is I'm pretty darned sure you can get away with deleting the columns of concern on your import. I would try a test on one product first to be sure, though.