Jump to content

monterey93940

Members
  • Content count

    31
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Ryan
  1. monterey93940

    Easy Populate & Products Attributes

    guys help. i added the retail price column with EZ fields. now when i load up i get this error -------------------------------- 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' '100' 'NULL')' at line 23 INSERT INTO products ( products_retail_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', '2', '20', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "1/18/2004 22:27", '1', '12', '12', '100' 'NULL') ----------------------------- i can use os to add and delete stuff but when i use EP i get the error above and then the items that are there gets duplicated. Please help been playing around for weeks.
  2. i have the same problem. but i have more. i used EZ fields to add field to the DB ------------------------------------------ 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' '100' 'NULL')' at line 23 INSERT INTO products ( products_retail_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', '2', '20', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "1/18/2004 22:27", '1', '12', '12', '100' 'NULL') ------------------------------------------- VJ Please help
  3. monterey93940

    Easy Populate

    Please help !!
  4. monterey93940

    Easy Populate

    Please help. i downloaded the file from EP and then added the 3rd product it says it added the new product but gives and error and the product doesn't show up please help. help help help ---------------------------------------- File uploaded. Temporary filename: /tmp/phpWs1oDv User filename: EP2004Jan12-1806.txt Size: 841 | 1 | | 12th | this is th | | 35 | 12 | | 1/12/2004 | 20 | | Fragrances | | | 45 | --none-- | Active Updated | 20 | sm_ANUCCI_ | third | this is th | | 15 | 20 | 1/12/2004 | 0000-00-00 | 20 | Calvin Kli | Fragrances | Women's | | 45 | Taxable Go | Active Updated | 3 | | one | hello | | 20 | 20 | 1/12/2004 | 0000-00-00 | 20 | Calvin Kli | Fragrances | Women's | | 100 | Taxable Go | Active !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_retail_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', '3', '20', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "1/12/2004 1:17", '1', '20', '20', '100' '10') -----------------------------
  5. monterey93940

    Easy Populate..

    i got it to work !! i get different error File uploaded. Temporary filename: /tmp/phpWs1oDv User filename: EP2004Jan12-1806.txt Size: 841 | 1 | | 12th | this is th | | 35 | 12 | | 1/12/2004 | 20 | | Fragrances | | | 45 | --none-- | Active Updated | 20 | sm_ANUCCI_ | third | this is th | | 15 | 20 | 1/12/2004 | 0000-00-00 | 20 | Calvin Kli | Fragrances | Women's | | 45 | Taxable Go | Active Updated | 3 | | one | hello | | 20 | 20 | 1/12/2004 | 0000-00-00 | 20 | Calvin Kli | Fragrances | Women's | | 100 | Taxable Go | Active !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_retail_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', '3', '20', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "1/12/2004 1:17", '1', '20', '20', '100' '10')
  6. monterey93940

    images in easy populate

    oh, now i might have to go find an image extrator thing. i have more that 4000 products. thank you for the post.
  7. monterey93940

    Easy Populate..

    i got it to work, i just downloaded the file and made changes there, now the question is adding another field called retailprice v_products_retail_price what do you think? v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_retail_price v_products_retail_price v_products_url_3 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_name_1_2 v_attribute_options_name_1_3 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_options_name_2_2 v_attribute_options_name_2_3 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_options_name_3_2 v_attribute_options_name_3_3 v_attribute_values_id_3_1 v_attribute_values_price_3_1 v_attribute_values_name_3_1_1 v_attribute_values_name_3_1_2 v_attribute_values_name_3_1_3 v_attribute_values_id_3_2 v_attribute_values_price_3_2 v_attribute_values_name_3_2_1 v_attribute_values_name_3_2_2 v_attribute_values_name_3_2_3 v_attribute_values_id_3_3 v_attribute_values_price_3_3 v_attribute_values_name_3_3_1 v_attribute_values_name_3_3_2 v_attribute_values_name_3_3_3 v_attribute_values_id_3_4 v_attribute_values_price_3_4 v_attribute_values_name_3_4_1 v_attribute_values_name_3_4_2 v_attribute_values_name_3_4_3 v_attribute_values_id_3_5 v_attribute_values_price_3_5 v_attribute_values_name_3_5_1 v_attribute_values_name_3_5_2 v_attribute_values_name_3_5_3 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_options_name_4_2 v_attribute_options_name_4_3 v_attribute_values_id_4_1 v_attribute_values_price_4_1 v_attribute_values_name_4_1_1 v_attribute_values_name_4_1_2 v_attribute_values_name_4_1_3 v_attribute_values_id_4_2 v_attribute_values_price_4_2 v_attribute_values_name_4_2_1 v_attribute_values_name_4_2_2 v_attribute_values_name_4_2_3 v_attribute_values_id_4_3 v_attribute_values_price_4_3 v_attribute_values_name_4_3_1 v_attribute_values_name_4_3_2 v_attribute_values_name_4_3_3 v_attribute_values_id_4_4 v_attribute_values_price_4_4 v_attribute_values_name_4_4_1 v_attribute_values_name_4_4_2 v_attribute_values_name_4_4_3 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_options_name_5_2 v_attribute_options_name_5_3 v_attribute_values_id_5_1 v_attribute_values_price_5_1 v_attribute_values_name_5_1_1 v_attribute_values_name_5_1_2 v_attribute_values_name_5_1_3 v_attribute_values_id_5_2 v_attribute_values_price_5_2 v_attribute_values_name_5_2_1 v_attribute_values_name_5_2_2 v_attribute_values_name_5_2_3 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR do you think i should put the retail price in the begining? thanks
  8. monterey93940

    Full install with price break

    amy have you done anything with adding a field using easy populate, i am trying to add a field. v_retail_price :(
  9. monterey93940

    [Contribution] Adding new fields to Easy Populate

    i get this error i downloaded my file and added a field v_products_retail_price on excel and tried uploading i get this error *************** File uploaded. Temporary filename: /tmp/phpwt0jjI User filename: testing small.txt Size: 20035 1054 - Unknown column 'p.products_retail_price' in 'field list' SELECT p.products_retail_price as v_products_retail_price, 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_weight as v_products_weight, p.products_date_added as v_date_avail, 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 FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = '125113' AND ptoc.categories_id = subc.categories_id [TEP STOP] *************** help
  10. monterey93940

    Full install with price break

    take it back didn't read the post right, but i am looking for this 'EZ New Fields' things.
  11. monterey93940

    Full install with price break

    fantastico !!!! is what i used to intall.
  12. monterey93940

    images in easy populate

    I am trying to point to images in a different url but it adds the local url and then the url of the image. http://shop.mysite.net//images/http://www....ges/picture.JPG http://www.picturesite.com/images/picture.JPG is where i want it to look for picture where can i change this configuration. Please help
  13. monterey93940

    Easy Populate..

    i am having the same problem. the file is uploaded to temp but nothing in the store
  14. monterey93940

    Easy Populate

    got past this, uploaded the file and it uploades to a temp directory. now how do i get it to show up in my store? I am reading the manual also...
  15. monterey93940

    making a tab-delimited file

    i got it !! thanks
×