♥geoffreywalton Posted April 26, 2013 Share Posted April 26, 2013 @@saupe31 Carl If the fields are not on the product file you will have to amend the EP script. The charges would have to be product related if you are using EP to amend them The script has comments throughout that explain what to do. HTH G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
partrade12 Posted April 26, 2013 Share Posted April 26, 2013 I have looked everywhere for this answer but can not find anything, anything will be greatly appreciated. Or point me to a link that will help... When I load my file to EP i get this error... 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 3.45, 217 ) [TEP STOP] (w00t)Im not sure what im missing Please Help!!!! Quote Link to comment Share on other sites More sharing options...
partrade12 Posted April 26, 2013 Share Posted April 26, 2013 Also my prices aren't showing up on my site. everything else shows up great.... Quote Link to comment Share on other sites More sharing options...
puddlec Posted April 26, 2013 Share Posted April 26, 2013 I have looked everywhere for this answer but can not find anything, anything will be greatly appreciated. Or point me to a link that will help... When I load my file to EP i get this error... 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 3.45, 217 ) [TEP STOP] (w00t)Im not sure what im missing Please Help!!!! there are no field names, to map what it has to insert those values to. which is why it comes out with that error. also which version of easy populate are you using? Quote Phoenix support now at https://phoenixcart.org/forum/ App created for phoenixTinyMCE editor for admin Link to comment Share on other sites More sharing options...
partrade12 Posted April 26, 2013 Share Posted April 26, 2013 Its the 2.8 Quote Link to comment Share on other sites More sharing options...
puddlec Posted April 26, 2013 Share Posted April 26, 2013 (edited) Its the 2.8 did a quick test and this worked for me (i have not got SPPC installed on mine) replace the code below (from line 3443 in easy_populate.php) // and insert the new record if ($v_customer_price_1 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_1 . ', ' . $v_customer_price_1 . ', ' . $v_products_id . ' )' ); } if ($v_customer_price_2 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_2 . ', ' . $v_customer_price_2 . ', ' . $v_products_id . ' )' ); } if ($v_customer_price_3 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_3 . ', ' . $v_customer_price_3 . ', ' . $v_products_id . ' )' ); } if ($v_customer_price_4 != ''){ $result = tep_db_query(' INSERT INTO '.TABLE_PRODUCTS_GROUPS.' VALUES ( ' . $v_customer_group_id_4 . ', ' . $v_customer_price_4 . ', ' . $v_products_id . ' )' ); } with // and insert the new record if ($v_customer_price_1 != ''){ $result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id) VALUES ('" . $v_customer_group_id_1 . "', '" . $v_customer_price_1 . "', '" . $v_products_id . "')"); } if ($v_customer_price_2 != ''){ $result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id) VALUES ('" . $v_customer_group_id_2 . "', '" . $v_customer_price_2 . "', '" . $v_products_id . "')"); } if ($v_customer_price_3 != ''){ $result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id) VALUES ('" . $v_customer_group_id_3 . "', '" . $v_customer_price_3 . "', '" . $v_products_id . "')"); } if ($v_customer_price_4 != ''){ $result = tep_db_query(" INSERT INTO " .TABLE_PRODUCTS_GROUPS . " (customers_group_id, customers_group_price, products_id) VALUES ('" . $v_customer_group_id_4 . "', '" . $v_customer_price_4 . "', '" . $v_products_id . "')"); } Edited April 26, 2013 by puddlec Quote Phoenix support now at https://phoenixcart.org/forum/ App created for phoenixTinyMCE editor for admin Link to comment Share on other sites More sharing options...
saupe31 Posted April 29, 2013 Share Posted April 29, 2013 @@saupe31 Carl If the fields are not on the product file you will have to amend the EP script. The charges would have to be product related if you are using EP to amend them The script has comments throughout that explain what to do. HTH G the fields are in the product file its just not importing properly Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted April 29, 2013 Share Posted April 29, 2013 @@saupe31 In that case have you used the correct names as the column titles? Download a full file and check what is exported against what you are using. HTH G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Reco-X Posted April 29, 2013 Share Posted April 29, 2013 is there a way to import the excel using the coluumns instead 1 column with the character separator? Quote Link to comment Share on other sites More sharing options...
Reco-X Posted April 30, 2013 Share Posted April 30, 2013 how i can convert a simple excel, to csv with the format that easy populate needs??? i have 10000 rows. Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted April 30, 2013 Share Posted April 30, 2013 @@Reco-X Lucas Use <File> <Save As> Then choose csv as the file type. HTH G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Reco-X Posted April 30, 2013 Share Posted April 30, 2013 Thanks, that works. i have a problem of logic, i have an excel with this data: Code, Name, Name_original, duration, review, director, link, people Where: Code Name Name_original Are description of the product, but i think duration, review, director, people, link are attributes, am i rigth?? How can i do the importation for the format i need?? The database is for movies, how do you think is the best way to do? Quote Link to comment Share on other sites More sharing options...
partrade12 Posted May 6, 2013 Share Posted May 6, 2013 all is fixed! Now I have another question, I have some items that are the same picture but because it may be a different size its a different item number. How would i set this up in the file to not list the same pict twice but just have the option to chose a size while also listing the different item numbers. PLEASE HELP!! Quote Link to comment Share on other sites More sharing options...
Guest Posted May 15, 2013 Share Posted May 15, 2013 Hi there i was hoping someone could help me i have downloaded the easy populate with product attributes for my site however it is not working at the moment. It can upload products fine but the product attributes function is not working. When i download all product listing it comes up saying all my products have lots of attributes which is not true and when i upload with attributes it does not upload the actual attributes just the products. It comes up with this when i upload | hotone | Hot Consol | waxsa | | 3 (32).jpg | 3 (32).jpg | | | | | | | | | | | | | | 10999.99 | | 2 | 31.4 | | 05/04/2012 | | Mirrors / | | Test | | | | | | | | | | | | 2 | Size | 9999999999 | Small: 120 | | 1E+23 | Medium: 15 | | 1E+15 | Large: 240 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Active !New Product! thanks alot for your help Quote Link to comment Share on other sites More sharing options...
Guest Posted May 15, 2013 Share Posted May 15, 2013 (edited) In addition im sure i downloaded the one that said + product attributes thanks alot for all help Edited May 15, 2013 by alexpacteau Quote Link to comment Share on other sites More sharing options...
partrade12 Posted May 15, 2013 Share Posted May 15, 2013 Does anyone know anything about using SPPC with easy populate? I cant seem to get my separate prices to show when I am signed in as one of the other types of customers. Please advise. Quote Link to comment Share on other sites More sharing options...
netman09 Posted May 23, 2013 Share Posted May 23, 2013 Can I use Easy Populate with jcommerce? I have it in there and configured but it won't create files or import. Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted May 24, 2013 Share Posted May 24, 2013 Gary You use EP with OSCOmmerce not Jcommerce which as you know is an extension for Joomla to display osc products. Have you installed the correct version of EP for the OSC shop you are using. Cheers G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
partrade12 Posted May 30, 2013 Share Posted May 30, 2013 i got everything i have installed from the oscommerce add-ons site Quote Link to comment Share on other sites More sharing options...
partrade12 Posted May 30, 2013 Share Posted May 30, 2013 sorry just noticed you were addressing some one else. I am having an issue with everything but my SPPC is showing up correctly, could anyone shed any light on what may cause this? Quote Link to comment Share on other sites More sharing options...
dfrancis Posted June 8, 2013 Share Posted June 8, 2013 (edited) Hi, I have used Easy Populate previously a few years ago on a previous install of OSCommerce so I'm familiar with how it works. This time, I installed 2.8-231 and am using OSC 2.3.3. I downloaded and edited a CSV file. When I upload and import, I don't get any of the changes in the database. No errors or warnings display. I verified the CSV uploaded to the temp directory and re-downloaded it to check it out and all looks well. I've studied the docs and have not found any clues about what I'm doing wrong. Any help would be greatly appreciated. My settings are: Settings & Info EP vers: 2.8-231 osCommerce Online Merchant v2.3 OS: Array HTTP: DB: PHP: Array (Zend: ) Temp Directory: /home/content/94/9783494/html/public_html/artfulcomics/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 Products Images: true Additional Images: false Additional Images: false More Pics: false UltraPics Pics: false HTC: false SPPC: false Extra Fields: false PDF Upload: false Master Products: false Edited June 8, 2013 by dfrancis Quote Link to comment Share on other sites More sharing options...
partrade12 Posted June 11, 2013 Share Posted June 11, 2013 I still cant get the SPPC to work with easy populate any help would be great! Quote Link to comment Share on other sites More sharing options...
partrade12 Posted June 11, 2013 Share Posted June 11, 2013 v_customer_price_1 v_customer_group_id_1 v_customer_price_2 v_customer_group_id_2 This is what the separate customer columns look like in my excel file, I have my consumer price and 2 other different prices that are different depending on the customer. What should this look like in my data base i just want to make sure everything is right trying to narrow this issue down. Thanks Quote Link to comment Share on other sites More sharing options...
puddlec Posted June 11, 2013 Share Posted June 11, 2013 is sppc working at all on your website. e.g. each customer group has a different price, when they are logged in. if you are not seeing this then there is a problem with that addon that needs to be fixed. you can test by changing the price of a product within the admin and not using easy populate partrade12 1 Quote Phoenix support now at https://phoenixcart.org/forum/ App created for phoenixTinyMCE editor for admin Link to comment Share on other sites More sharing options...
partrade12 Posted June 14, 2013 Share Posted June 14, 2013 Yes I am not seeing the change of prices thats the problem, is there anything I should look at or post up here that you could look at that would be causing this issue? Thank you for responding! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.