Easy Populate & Products Attributes

[Mr.81]

Having a problem with the "Date Added" - could it be EP-related?

 

http://www.oscommerce.com/forums/topic/353649-date-added-wrong/page__gopid__1483107entry1483107

[surfalot]

Having a problem with the "Date Added" - could it be EP-related?

 

http://forums.oscomm...7entry1483107

 

the format you should use for the date is mentioned in the Requirements section of the EP docs.

[surfalot]

Hello,

 

I would like to know if this is a normal behavior of EP ?

 

By using CUSTOM download:

when I mark: price, quantity OR

price, quantity, vendor (a new field I created)

And I believe also at any combination I choose..

 

I get multiplied of "product_model" in the excel column. I assume because, I use the same "product model" for various Categories and sub Categories, and thats fine for me..

 

BUT, when I use "quick links" and download by model,price,quantity I get ONE single "product model" and no multiplied "product model"... !

 

Is it normal behavior of EP and I should't worry about, or I have a problem somewhere that I should fix?

 

I use Easy Populate 2.76h-MS2

 

Thanks a lot for your kind attention..

 

Best Regards,

Nathli

that is normal behaviour. not necessarily ideal, but that is normal

[Nathali]

that is normal behaviour. not necessarily ideal, but that is normal

 

Thanks again, Todd for your kind reply!

 

Best Regards,

[christianbright]

This is a peculiar error I'm getting. I'm able to upload files without issue, as well as export them. The temp dir is working and writable. However the import is not working for me. I get this error, and I've looked through as many pages as I can stand to look at without finding my problem.

 

Warning: Invalid argument supplied for foreach() in public_html/catalog/admin/easypopulate.php on line 1308

 

Any help?

[surfalot]

This is a peculiar error I'm getting. I'm able to upload files without issue, as well as export them. The temp dir is working and writable. However the import is not working for me. I get this error, and I've looked through as many pages as I can stand to look at without finding my problem.

 

Warning: Invalid argument supplied for foreach() in public_html/catalog/admin/easypopulate.php on line 1308

 

Any help?

I can help, but you need to help me help you. Look at the Support section of the docs in any version I uploaded. You will find a section called "how to ask for help".

[christianbright]

Sure thing. Here's the information:

 

Settings & Info

 

EP vers: 2.76i-MS2

osCommerce Online Merchant v2.2 RC2a

OS: Linux 2.6.18-164.11.1.el5

HTTP: Apache

DB: MySQL 5.0.81-community-log

PHP: 5.2.11 (Zend: 2.2.0)

 

Temp Directory:

/home/user/public_html/catalog/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

Additional Images: false

More Pics: false

UltraPics Pics: false

HTC: false

SPPC: false

Extra Fields: false

PDF Upload: false

 

Using Windows 7, Firefox, cPanel to edit the file.

 

My issue is neither upload nor download related. The only error I receive is when importing an already uploaded file as follows:

 

Filename: EP2010Feb12-1402.csv

 

Warning: Invalid argument supplied for foreach() in /home/user/public_html/catalog/admin/easypopulate.php on line 1308

Edited February 13, 2010 by christianbright

[jestep]

1) Easy Populate - Settings & Info – www.alphanautical.com

EP vers: 2.76i-MS2

osCommerce Online Merchant v2.2 RC2a

OS: Linux 2.6.18-92.1.18.el5PAE

HTTP: Apache

DB: MySQL 5.0.89-community

PHP: 5.2.12 (Zend: 2.2.0)

 

Temp Directory:

/home/alphanau/public_html//catalog/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

Additional Images: false

More Pics: false

UltraPics Pics: false

HTC: true

SPPC: false

Extra Fields: false

PDF Upload: false

2) OPERATING SYSTEM INFO: Windows

Editing Software: Dreamweaver

Spreadsheets: Excel

Browsers: Internet Explorer & Mozilla

 

3) Error Description:

Problem: In a full upload of all fields except Attributes, the Special Price which was entered, did not appear or exist after updating but everything else worked fine.

 

Following the Easy Populate instructions my original upload had this header:

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_specials_price v_products_weight v_date_added v_date_avail v_products_quantity v_manufacturers_name v_categories_image_1 v_categories_name_1_1 v_categories_image_2 v_categories_name_2_1 v_products_head_title_tag_1 v_products_head_desc_tag_1 v_products_head_keywords_1 v_tax_class_id v_status EOREOR Full Description

 

NOTE: Using v_products_specials_price and also v_tax_class_id

 

There was valid data in the special price column & Taxable Goods in the other column.

After loading, tax class showed to be None instead of Taxable Goods.

After simply changing the header in the CSV file from v_tax_class_id to v_tax_class_title it worked OK

 

On the Special price field, the instruction say to use v_products_specials_price and a download produces the column header v_products_specials_price.

However, in the Easy Populate program and in my actual current database, the database field in the specials table is specials_new_products_price.

 

I ran a sample of 30 products until I had everything formatted like I wanted. Then I made a update of over 1,000 products with another 30,000 to go so I am

keenly interested in a fix rather than manually entering the special prices manually.

Thanks

jestep

[surfalot]

Sure thing. Here's the information:

 

Filename: EP2010Feb12-1402.csv

 

Warning: Invalid argument supplied for foreach() in /home/user/public_html/catalog/admin/easypopulate.php on line 1308

 

all I can do is guess then since you haven't provided a snip of your file. Could be any of these: permissions, ownership, no header row, empty file.

[christianbright]

all I can do is guess then since you haven't provided a snip of your file. Could be any of these: permissions, ownership, no header row, empty file.

 

v_products_model v_status v_products_name_1 v_products_description_1 v_products_price v_products_quantity v_products_weight v_date_added v_categories_image_1 v_categories_name_1_1 v_categories_image_2 v_categories_name_2_1 v_categories_image_3 v_categories_name_3_1 v_categories_image_4 v_categories_name_4_1 v_categories_image_5 v_categories_name_5_1 v_categories_image_6 v_categories_name_6_1 v_categories_image_7 v_categories_name_7_1 EOREOR

Active 1,000 Gold 1,000 Gold - WoW US - Akama (Horde) 6.99 0 0 2010-02-08 12:08:51 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 10,000 Gold 10,000 Gold - WoW US - Akama (Horde) 69.9 0 0 2010-02-10 05:23:45 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 100,000 Gold 100,000 Gold - WoW US - Akama (Horde) 699 0 0 2010-02-10 05:27:50 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 15,000 Gold 15,000 Gold - WoW US - Akama (Horde) 104.85 0 0 2010-02-10 05:24:39 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 2,000 Gold 2,000 Gold - WoW US - Akama (Horde) 13.98 0 0 2010-02-10 05:20:13 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 20,000 Gold 20,000 Gold - WoW US - Akama (Horde) 139.8 0 0 2010-02-10 05:25:13 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 4,000 Gold 4,000 Gold - WoW US - Akama (Horde) 27.96 0 0 2010-02-10 05:20:50 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 40,000 Gold 40,000 Gold - WoW US - Akama (Horde) 279.6 0 0 2010-02-10 05:25:50 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 6,000 Gold 6,000 Gold - WoW US - Akama (Horde) 41.94 0 0 2010-02-10 05:21:36 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 60,000 Gold 60,000 Gold - WoW US - Akama (Horde) 419.4 0 0 2010-02-10 05:26:24 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 8,000 Gold 8,000 Gold - WoW US - Akama (Horde) 55.92 0 0 2010-02-10 05:23:02 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

Active 80,000 Gold 80,000 Gold - WoW US - Akama (Horde) 559.2 0 0 2010-02-10 05:26:57 World of Warcraft Gold WoW US Realms A Akama (Horde) EOREOR

 

It looked to me like the file had generated properly. My permissions on the temp folder are 755 and it says they were writable...

[surfalot]

3) Error Description:

Problem: In a full upload of all fields except Attributes, the Special Price which was entered, did not appear or exist after updating but everything else worked fine.

 

works well for me. could have save some typing and just offered the above desc and a sample of the file.:)

[surfalot]

It looked to me like the file had generated properly. My permissions on the temp folder are 755 and it says they were writable...

you need to link a file somewhere (as is says in the how to ask for help). the board changes it so I can't look for some of the problems.

[christianbright]

Ah sorry I thought you only wanted it for an upload or download issue. Here it is. I might also mention that I'm not trying to import to more than one category. In this case it's a specific server for the game Warcraft, uploading my products to it. http://goldmonger.net/buy/EP2010Feb12-1402.csv

Edited February 13, 2010 by christianbright

[surfalot]

Ah sorry I thought you only wanted it for an upload or download issue. Here it is. I might also mention that I'm not trying to import to more than one category. In this case it's a specific server for the game Warcraft, uploading my products to it. http://goldmonger.ne...0Feb12-1402.csv

 

the first thing I see is that you have no model number in the model number column. A unique model number is required in to allow the code to find the specific product to update or create. If you have additional issues, fix that one and post a new request at that time, good luck!

[christianbright]

Hmmm. My products are all virtual, and I hadn't even seen an option to generate a model number for them.

[christianbright]

Nevermind. I found it under Product Attributes and added a model number. Now I have found out that the error is happening during upload as well. Not only during importing. That is the only error line that appears, however. It's not as lengthy as the example in the documentation or what others experience.

Edited February 14, 2010 by christianbright

[jestep]

works well for me. could have save some typing and just offered the above desc and a sample of the file.:)

[jestep]

I think I have an idea as to what is causing the problem of the special price not being uploaded for me.

 

First step I took was to download (on the fly) selecting all options except attributes in a small little test category that I had built in the last couple of days.

 

This produced a CSV file.

I started comparing it to my data and I noticed the following:

1) The download did not have the three HTC fields in it.

2) The downloaded fields in each record were in a different sequence than was I was using.

3) The data in the downloaded fields and my data were virtually identical.

4) The data in all the v_products_specials_price fields was blank.

 

So to prove to myself that your statement that the special price worked, I simply entered in the correct special prices in the downloaded file and re-uploaded it. Sure enough, it worked!

 

My first thought was that it was the HTC data causing the problem. So, I took a recent test file of about 30 products and deleted the 3 HTC fields using the sequence of fields I had been using. To my surprise, that did not work. So, I thought it must be the sequence of the fields. I rearranged my data into the same sequence as the downloaded data except that I added the 3 HTC fields just before the EOREOR marker. Again I was surprised that my special prices did not show up. Finally, I took my data sample, rearranged into the same sequence as the downloaded data AND I deleted the three HTC fields. Well, you guessed it, it worked and I had special prices on this sample.

 

I looked at the PHP code in Easy Populate but I don't see a logic error. Maybe you can find it.

 

Since I need the HTC fields, I am going to try to continue on with the new (downloaded sequence of fields) sequence and leave in the 3 HTC fields just before the EOREOR marker. I am also going to delete out the 5 additional sets of category fields and images that were blank since I only need two levels. After they are deleted out, with one file on the top half of the screen and the other on the bottom half of the screen, the two files appear to be identical.

 

If anyone else is using EP and Linda's three HTC fields, I would be interested in knowing if they are having any problems with the special Price.

 

Thanks

(Snowed in in Dallas!)

jestep

[surfalot]

Nevermind. I found it under Product Attributes and added a model number. Now I have found out that the error is happening during upload as well. Not only during importing. That is the only error line that appears, however. It's not as lengthy as the example in the documentation or what others experience.

 

actually, the proper model number is the model number on the product edit page.

[surfalot]

I think I have an idea as to what is causing the problem of the special price not being uploaded for me.

 

First step I took was to download (on the fly) selecting all options except attributes in a small little test category that I had built in the last couple of days.

 

you really are going to make me beg you for a sample file causing the failure aren't you? There really is a reason the docs ask you to provide it in your request for help. may have even saved you a few days and a headache. :thumbsup:

[jestep]

you really are going to make me beg you for a sample file causing the failure aren't you? There really is a reason the docs ask you to provide it in your request for help. may have even saved you a few days and a headache. :thumbsup:

[jestep]

I think I have an idea as to what is causing the problem of the special price not being uploaded for me.

 

First step I took was to download (on the fly) selecting all options except attributes in a small little test category that I had built in the last couple of days.

 

This produced a CSV file.

I started comparing it to my data and I noticed the following:

1) The download did not have the three HTC fields in it.

2) The downloaded fields in each record were in a different sequence than was I was using.

3) The data in the downloaded fields and my data were virtually identical.

4) The data in all the v_products_specials_price fields was blank.

 

So to prove to myself that your statement that the special price worked, I simply entered in the correct special prices in the downloaded file and re-uploaded it. Sure enough, it worked!

 

My first thought was that it was the HTC data causing the problem. So, I took a recent test file of about 30 products and deleted the 3 HTC fields using the sequence of fields I had been using. To my surprise, that did not work. So, I thought it must be the sequence of the fields. I rearranged my data into the same sequence as the downloaded data except that I added the 3 HTC fields just before the EOREOR marker. Again I was surprised that my special prices did not show up. Finally, I took my data sample, rearranged into the same sequence as the downloaded data AND I deleted the three HTC fields. Well, you guessed it, it worked and I had special prices on this sample.

 

I looked at the PHP code in Easy Populate but I don't see a logic error. Maybe you can find it.

 

Since I need the HTC fields, I am going to try to continue on with the new (downloaded sequence of fields) sequence and leave in the 3 HTC fields just before the EOREOR marker. I am also going to delete out the 5 additional sets of category fields and images that were blank since I only need two levels. After they are deleted out, with one file on the top half of the screen and the other on the bottom half of the screen, the two files appear to be identical.

 

If anyone else is using EP and Linda's three HTC fields, I would be interested in knowing if they are having any problems with the special Price.

 

Thanks

(Snowed in in Dallas!)

jestep

[jestep]

Ok - I am including access to 4 "005" CSV upload files at www.Alpahnautical.com/shop/

Two of these are "1-30" meaning they are small test files with 30 records. One I processed first and it included the three HTC fields. As I recollect, it did not produce Special prices, but when I uploaded the other 30 product test file with the "wo_HTC" I used the same data & deleted the three HTC fields. The Special prices immediately appeared.

 

There is a third file with "1082" records which has been processed already. When you check the web site you will see that none of these products (other than the 30 in the test just mentioned) have a Special price.

 

There is another larger file with about 2000+ products that I will process as when there is a solution to the Special prices problem.

 

I could add a 5th file (if needed) for the 1082 records in the "004" format where the sequence of the fields is more like in the EP instructions as opposed to the 005 sequence which is more like you get from an on-the-fly download with everything selected except attributes.

 

Two other "minor" things to note:

a) It seems that to get the uploaded images to be turned on and visible I need to manually upload them from the local to the remote image sub-directory. It was my impression that they should be properly uploaded to the correct sub-directory in the remote images folder AND be visible.

B) As I mentioned to you once before, I have the Cieto Featured products contribution installed. I have to manually update the Products Short Description for every record added. When you have the time, this would be an important addition to EP just like Linda's HTC contribution.

 

The reason I mention this is that if the Special price worked and the 2 "minor" things also worked, I could load the 30,000 products from this current distributor with no human intervention instead of having to tweek every record. Big difference in time and money.

 

Thanks for doing a great job on EP!

jestep

[surfalot]

Two other "minor" things to note:

a) It seems that to get the uploaded images to be turned on and visible I need to manually upload them from the local to the remote image sub-directory. It was my impression that they should be properly uploaded to the correct sub-directory in the remote images folder AND be visible.

B) As I mentioned to you once before, I have the Cieto Featured products contribution installed. I have to manually update the Products Short Description for every record added. When you have the time, this would be an important addition to EP just like Linda's HTC contribution.

 

The reason I mention this is that if the Special price worked and the 2 "minor" things also worked, I could load the 30,000 products from this current distributor with no human intervention instead of having to tweek every record. Big difference in time and money.

The time and money thing is simply a given for everyone's request, certainly not a motivator for me.:D

 

I can't get to the files.

 

a) yes, you have to upload the images. all referenced image name must already exist on the site. EP manipulates the database only, with the small exception of deleting products it will delete the images also since that function was copied directly from the base code.

 

b)with regard to the added field, an easy method of adding fields from the products and products_description tables was added a few versions back. You should be looking in the easypopulate.php settings for help in this area. Full instructions are there.

[Mr.81]

the format you should use for the date is mentioned in the Requirements section of the EP docs.

Thanks for the reply. I tried using the YYYY-MM-DD format but now it's saying the products were added on Wednesday, 31. December 1969 - could this be because the english.php was edited due to instruction to do so in another thread?

 

Thanks!