Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

@@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

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

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!!!!

Link to comment
Share on other sites

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?

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

Link to comment
Share on other sites

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 by puddlec

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

Link to comment
Share on other sites

@@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

Link to comment
Share on other sites

@@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

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

@@Reco-X

 

Lucas

 

Use

<File>

<Save As>

 

Then choose csv as the file type.

 

HTH

 

G

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

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?

Link to comment
Share on other sites

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!!

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

In addition im sure i downloaded the one that said + product attributes

 

thanks alot for all help

Edited by alexpacteau
Link to comment
Share on other sites

  • 2 weeks later...

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

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

  • 2 weeks later...

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 by dfrancis
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

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...