Jump to content

jjm001

Members
  • Content count

    5
  • Joined

  • Last visited

  1. (Sorry for providing insufficient info earlier, here's it) Hey guys, I have a quite strange problem with updating my database. I have about 100 products in each 8 categories and I am uploading 1 category at a time. The problem is when I import .csv file, it lists every product as 'updated' but in the store, it's only the last product in the csv that is added. In one category I already had 32 products, so now if I add products in that, it remains just 32 by adding only the first 32 products, In another category where I already had 2 products, it remains 2 by replacing the old ones (or only alphabetically first 2 are added). So can't update anymore products, pls help! I am using WinXP and MS Excel '07 to edit .csv ----------------------------------------------- Settings and Info: EP vers: 2.76h-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.28 HTTP: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 DB: MySQL 5.1.30 PHP: 5.2.9 (Zend: 2.2.0) Temp Directory: /home/chandrik/public_html/catalog/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: on Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false ----------------------------------------------- Files : I tried this csv file http://www.chandrikamasala.com/catalog/temp/EP-misc.csv also delimited txt file http://www.chandrikamasala.com/catalog/temp/EP-misc.txt ----------------------------------------------- Any solution????
  2. Hey guys, I have a quite strange problem with updating my database. I have about 100 products in each 8 categories and I am uploading 1 category at a time. The problem is when I import .csv file, it lists every product as 'updated' but in the store, it's only the last product in the csv that is added. In one category I already had 32 products, so now if I add products in that, it remains just 32 by adding only the first 32 products, In another where I already had 2 products, it remains 2 by replacing the old ones (or only alphabetically first 2 are added) Any solution????
×