Jump to content
VJ

Easy Populate & Products Attributes

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

Share this post


Link to post
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!!!!

Share this post


Link to post
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?

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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 ======>>>>>.

Share this post


Link to post
Share on other sites

how i can convert a simple excel, to csv with the format that easy populate needs???

 

i have 10000 rows.

Share this post


Link to post
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 ======>>>>>.

Share this post


Link to post
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?

Share this post


Link to post
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!!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

thanks alot for all help

Edited by alexpacteau

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Can I use Easy Populate with jcommerce? I have it in there and configured but it won't create files or import.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×