Printable View
I'm not sure I follow you. You downloaded the details, but the descriptions aren't showing...Quote:
Originally Posted by Erica
Are you saying the downloaded file doesn't contain the descriptions, or that your edits don't show after uploading, or that after uploading ALL your products no longer have descriptions?
i started initially with a blank sheet, and added all bits except the descriptions and uploaded it all and it worked great. i then went and customised the rest of the site. this evening i went to admin/tools/easy populate .. and downloaded the complete delimited file. i opened it up in excel and started copying and pasting descriptions. i only did a few full ones and the rest i put 'info to follow' in the space. i uploaded the file and the descriptions are not showing on the products.Quote:
Originally Posted by DrByte
Sorry .. i just tried again, as i was describing what i was doing .. and its working :blush: sorry .. i obviously did something wrong last time
Erica xx
Thanks for the tip. Looking in the DB at the products and products_description tables I observe the products uploaded via EP appear ok in the products table but do not appear in the products_description table.Quote:
Originally Posted by langer
Any possible causes?
The products I added manually via admin appear in both tables (and display correctly).
The products and products_description table structure follows. (all default ZC 1.3.0.2 fresh install structure)
--Code:Products table structure
products
Field Type Null Default
products_id int(11) No
products_type int(11) No 1
products_quantity float No 0
products_model varchar(32) Yes NULL
products_image varchar(64) Yes NULL
products_price decimal(15,4) No 0.0000
products_virtual tinyint(1) No 0
products_date_added datetime No 0001-01-01 00:00:00
products_last_modified datetime Yes NULL
products_date_available datetime Yes NULL
products_weight float No 0
products_status tinyint(1) No 0
products_tax_class_id int(11) No 0
manufacturers_id int(11) Yes NULL
products_ordered float No 0
products_quantity_order_min float No 1
products_quantity_order_units float No 1
products_priced_by_attribute tinyint(1) No 0
product_is_free tinyint(1) No 0
product_is_call tinyint(1) No 0
products_quantity_mixed tinyint(1) No 0
product_is_always_free_shipping tinyint(1) No 0
products_qty_box_status tinyint(1) No 1
products_quantity_order_max float No 0
products_sort_order int(11) No 0
products_discount_type tinyint(1) No 0
products_discount_type_from tinyint(1) No 0
products_price_sorter decimal(15,4) No 0.0000
master_categories_id int(11) No 0
products_mixed_discount_quantity tinyint(1) No 1
metatags_title_status tinyint(1) No 0
metatags_products_name_status tinyint(1) No 0
metatags_model_status tinyint(1) No 0
metatags_price_status tinyint(1) No 0
metatags_title_tagline_status tinyint(1) No 0
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 15 products_id
idx_products_date_added_zen INDEX None products_date_added
idx_products_status_zen INDEX None products_status
Code:Products_description table structure
products_description
Field Type Null Default
products_id int(11) No
language_id int(11) No 1
products_name varchar(64) No
products_description text Yes NULL
products_url varchar(255) Yes NULL
products_viewed int(5) Yes 0
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 4 products_id
language_id
idx_products_name_zen INDEX None products_name
I cleared the text in each products description field in the spreadsheet and instead just entered D1 for each product description and then uploaded. But same negative result.
It is strange why one table would get updated but the other table would not.
Any other tables I should look at?
Wonder if the mod_security filtering on server is contributing to this isssue?
And I just did the same for model numbers. Cleared them all out and instead entered simple unique numerics for each product model eg. 1, 2, 3 etc. no errors reported but same negative result. Any clues?
Yes, it's tab-delimitedQuote:
Originally Posted by DrByte
Yes, EOREOR ends every line
No, it doesn't act differently using ftp.
I still get the error:
Quote:
File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information
Can someone please tell me what the header fields for 3.0.2 are?
Many are the same as older versions, but many are also different! Especially the categories. I have already tried creating and downloading all of the test files available in ep, and NONE of them show me what to name my sub categories. In fact those data files and data templates you can create and download as examples are completely useless.:huh:
What do you name the master category, and subsequent sub-categories.
Thanks,
Tom
Hi again,
for some reason, when i go to split my file of around 7000 items, it will only split twice, and then those two splits only have around 600 items each!
I know I saved it correctly, and all of that, but I'm not sure what's going on.
This time, it told me this:
Not sure what to do w/ that information though.Quote:
Warning: fopen(/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1126
Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1129
Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1141
Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1168
Support for the advanced version is not offered here.Quote:
Originally Posted by wtashby
Any thoughts?