Hi,
I have installed osCommerce Merchant v2.3.1 and Easy Populate Easy Populate V2.77a.. With intention to fully managing my store on Excel and import my products including pic reference straight into my store using csv
I have created a test CSV file and inserted 5 products under 2 categories.
When I choose Upload and Import EP File and hit insert into db everything seems to work
MG200MMS | Matrox G20 | Reinforcin | www.matrox | matrox/mg2 | 299.99 | | 32 | 23 | | 39521.0653 | category_h | Hardware | subcategor | Graphics C | | | | | | | | | | | | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | 100 | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | 50 | 3 | 16 mb | 70 | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | Taxable Go | Active !New Product!
| MG400-32MB | Matrox G40 | Dramatical | www.matrox | matrox/mg4 | 499.99 | | 32 | 23 | | 39521.0653 | category_h | Hardware | subcategor | Graphics C | | | | | | | | | | | | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | 120 | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | -10 | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | Taxable Go | Active !New Product!
| MSIMPRO | Microsoft | Every elem | www.micros | microsoft/ | 49.99 | | 2 | 7 | | 39521.0653 | category_h | Hardware | subcategor | Mice | | | | | | | | | | | | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | Taxable Go | Active !New Product!
| DVD-RPMK | The Replac | Regional C | www.replac | dvd/replac | 42 | | 13 | 23 | | 39521.0653 | category_d | DVD Movies | subcategor | Action | | | | | | | | | | | | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | Taxable Go | Active !New Product!
| DVD-BLDRND | Blade Runn | Regional C | www.blader | dvd/blade_ | 35.99 | | 17 | 7 | | 39521.0653 | category_d | DVD Movies | subcategor | Science Fi | | | | | | | | | | | | 1 | Color | 2 | Size | 3 | Model | 5 | Value | | 6 | Premium | | 7 | Deluxe | | 8 | PS/2 | | 9 | USB | | 4 | Memory | 1 | 4 mb | | 2 | 8 mb | | 3 | 16 mb | | 4 | 32 mb | | 5 | Version | 10 | Download: | | 13 | Box: Windo | | Taxable Go | Active !New Product!
The problem that I have is that Easy Populate populates the database with products and I can see the products (not the pictures) when I browse the store but when I go to osCommerce/admin options Catalog - Categories/Products osCommerce picks up the 2 new categories but it tells me I have 0 products.
Categories / Products Status Action DVD Movies Hardware Categories: 2
Products: 0
If I manually add another product it appears under osCommerce/admin options Catalog - Categories/Products..
I also when I try to export my products I get empty CSV file.
Any help will be greatly appreciated..
Tomek
Configuration:
Settings & Info
EP vers: 2.77a
osCommerce Online Merchant v2.3
OS: Array
HTTP:
DB:
PHP: Array (Zend: )
Temp Directory:
/var/www/www.ladiesworld.com.au/temp/
Temp Dir is Writable
Magic Quotes is: off
register_globals is: off
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
Other Support:
MVS Support: false
Additional Images: false
More Pics: false
UltraPics Pics: false
Unlimited Images: false
HTC: false
SPPC: false
Extra Fields: false
PDF Upload: false
Quick Backup Enabled: true