Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate


Guest

Recommended Posts

I had successfully added EP and exported and created files just fine. However, when trying to import the file with a change to price it fails and produces the following error. We have double checked documentation and have tried to find a similar error in the threads. We even reduced the number of lines being imported so we didn't have to deal with splitting the file. We have also tried the suggestions of saving the file from Excel as different formats before re-importing. Here is the error message - after that is the info of what version of EP I'm running on. After that is the sample file we were trying to import with the headers listed. My biggest thanks in advance for any suggestions...I'm not a techie - but, I was very happy I was able to install EP and actually produce the files. I worship the ground you walk on!!!! :lol:

 

File uploaded.

Temporary filename: /var/tmp/phpLzh0mo

User filename: test2.txt

Size: 79474

1054 - Unknown column 'p.products_cost' in 'field list'

 

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_cost as v_products_cost, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'MP5500' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1

 

[TEP STOP]

 

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce 2.2-MS2

OS: Linux 2.6.22-19_1.BHsmp

HTTP: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8g DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.0.45-community-log

PHP: 5.2.6 (Zend: 2.2.0)

 

Temp Directory:

/home/ematrixs/public_html/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 27000 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: false

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

v_products_model v_products_price v_products_quantity EOREOR

MP5500 2199.99 100 EOREOR

A-RMPT515000 2199.99 100 EOREOR

52PFL3603D 2199.99 100 EOREOR

EOS-40D 2188.88 100 EOREOR

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...