Easy Populate & Products Attributes

[Guest]

how did you post the data via phpmyadmin from the text file? it doesnt go into one table, goes into multiple tables

[GR8M8]

John

It did go into multiple tables. But not the Prices & Qty Blocks

 

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_price v_products_quantity v_products_price1 v_products_price1_qty v_products_price2 v_products_price2_qty v_products_price3 v_products_price3_qty v_products_price4 v_products_price4_qty products_qty_blocks v_categories_name_1 v_categories_name_2 v_categories_name_3 v_products_weight v_manufacturers_name v_date_avail v_date_added v_products_url_1 v_tax_class_title v_status EOREOR

ABRSB abrsb.jpg 100x70x25mm FLEXISAND SANDING BLOCK<br>MEDIUM / FINE 100x70x25mm FLEXISAND SANDING BLOCK MEDIUM / FINE 1.98 1 1.98 1 1.65 20 Abrasives Sanding Sponges 05-05-05 Taxable Goods Active EOREOR

 

 

Ray

[GR8M8]

That wasn't very clear

That was straight from Excel

 

This from EP

File uploaded.

Temporary filename: /tmp/phpAXTMYi

User filename: prod.txt

Size: 718

| ABRSB | abrsb.jpg | 100x70x25m | 100x70x25 | 1.98 | 1 | 1.98 | 1 | 1.65 | 20 | | | | | | Abrasives | Sanding Sp | | | | | 05-05-05 | | Taxable Go | Active Updated

| | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

 

All OK but the price and Qty blocks

 

Ray

[GR8M8]

John

 

This is how the field are listed in my db

 

`products_id`,

`products_quantity`,

`products_price1_qty`,

`products_price2_qty`,

`products_price3_qty`,

`products_price4_qty`,

`products_qty_blocks`,

`products_model`,

`products_image`,

`products_bimage`,

`products_price`,

`products_price1`,

`products_price2`,

`products_price3`,

`products_price4`,

`products_date_added`,

`products_last_modified`,

`products_date_available`,

`products_weight`,

`products_status`,

`products_tax_class_id`,

`manufacturers_id`,

`products_ordered`

 

Does this sequence have any effect on the information getting to the correct fields?

 

Ray

[Guest]

i didnt put the price break ep contribution together, you will need to check the code for accuracy

[AverageJoe]

John, since about 90% of the questions asked are pretty much the same, have you ever thought of writing a FAQ for the Knowledge Base and then point people to that? I'd take a stab at it, but I just don't know enough about EP :-"

[Guest]

all the info is in the docs, it is people who make changes to the contributions, then change it from the default. like the last one, someone changed the default from tab delimited to semicolon.

other problem is most hosts change the document root to a path, not $DOCUMENT_ROOT

[GR8M8]

John

Thanks for your efforts

Ray

[GR8M8]

Could the 'sort_order' affect the insertion into the db?

 

Ray

[GR8M8]

John

Thanks for your efforts

 

Could the 'sort_order' affect the insertion into the db?

 

Ray

[Guest]

how did you program the insertion?

[GR8M8]

I have tried two ways

Through EP and through MyPhpAdmin "products" table very last line "Insert data from a textfile into table"

 

I got the 'sort order' from Admin_categories

 

Ray

[GR8M8]

I also have Price_break 1.11.3 installed which could be causing a conflict

Ray

[Dada1]

Ok it is populating the list now, but it is only showing one item in the catalog.

File uploaded.

Temporary filename: /tmp/phpPCzFys

User filename: terminal tackle.csv

Size: 33728

| 13508 | 6550000 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 33 | $0.47 | 0.05 | | | | | | 13509 | 6550001 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 34 | $0.47 | 0.01 | | | | | | 13510 | 6550002 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 33 | $0.47 | 0.01 | | | | | | 13511 | 6550003 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 36 | $0.47 | 0.01 | | | | | | 13512 | 6550004 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 40 | $0.47 | 0.01 | | | | | | 13513 | 6550005 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 35 | $0.47 | 0.01 | | | | | | 13514 | 6550006 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 22 | $0.47 | 0.01 | | | | | | 13515 | 6550007 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 47 | $0.47 | 0.01 | | | | | | 13516 | 6550010 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 15 | $1.89 | 0.05 | | | | | | 13517 | 6550011 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 18 | $1.89 | 0.05 | | | | | | 13518 | 6550012 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 20 | $1.89 | 0.05 | | | | | | 13519 | 6550013 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | $1.89 | 0.05 | | | | | | 13520 | 6550014 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | $1.89 | 0.05 | | | | | | 13521 | 6550015 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | $1.89 | 0.01 | | | | | | 13522 | 6550016 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 20 | 1.26 | 0.15 | | | | | | 13523 | 6550017 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 10 | 1.26 | 0.15 1352 | 6550020 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 36 | 0.37 | 0.01 1352 | 6550021 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 36 | 0.37 | 0.01 1352 | 6550022 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 46 | 0.37 | 0.01 1352 | 6550023 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 36 | 0.37 | 0.05 1352 | 6550024 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1352 | 6550025 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1353 | 6550026 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1353 | 6550027 | | 3-Way Swiv | Eagle Claw | Fishing | Terminal T | 14 | 0.37 | 0.01 1353 | 6550030 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 67 | 0.92 | 0.01 1353 | 6550031 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 60 | 0.92 | 0.01 1353 | 6550032 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 55 | 0.92 | 0.01 1353 | 6550033 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 72 | 0.92 | 0.01 1353 | 6550034 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 24 | 0.92 | 0.01 1353 | 6550035 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 36 | 0.92 | 0.01 1353 | 6550036 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 36 | 0.92 | 0.3 13539 | 6550040 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 12 | 0.92 | 0.01 1354 | 6550041 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 36 | 0.92 | 0.01 1354 | 6550042 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 36 | 0.92 | 0.01 1354 | 6550043 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 54 | 0.92 | 0.01 1354 | 6550044 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 23 | 0.92 | 0.01 1354 | 6550045 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 23 | 0.92 | 0.01 1354 | 6550050 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 24 | 0.92 | 0.01 1354 | 6550051 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 23 | 0.92 | 0.01 1354 | 6550052 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 20 | 0.92 | 0.01 1354 | 6550053 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 20 | 0.92 | 0.01 1354 | 6550054 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 14 | 0.92 | 0.01 1355 | 6550055 | | Ball Beari | Eagle Claw | Fishing | Terminal T | 15 | 0.92 | 0.01 1355 | 6550060 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 40 | 0.3 | 0.01 1355 | 6550061 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 51 | 0.3 | 0.01 1355 | 6550062 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 38 | 0.3 | 0.01 1355 | 6550063 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 62 | 0.3 | 0.01 1355 | 6550064 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 23 | 0.3 | 0.01 1355 | 6550065 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 17 | 0.3 | 0.01 1355 | 6550066 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 31 | 0.3 | 0.01 1355 | 6550067 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 25 | 0.3 | 0.01 1355 | 6550068 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 13 | 0.3 | 0.05 1356 | 6550070 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 131 | 0.64 | 0.1 13561 | 6550071 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 319 | 0.64 | 0.1 13562 | 6550072 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 339 | 0.64 | 0.1 13563 | 6550073 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 357 | 0.64 | 0.05 1356 | 6550074 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 242 | 0.64 | 0.01 1356 | 6550075 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 0.64 | 0.05 1356 | 6550076 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 0.64 | 0.05 1356 | 6550077 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 0.84 | 0.1 13568 | 6550078 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 63 | 0.84 | 0.05 1356 | 6550080 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.3 | 0.05 1357 | 6550081 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 65 | 0.3 | 0.01 1357 | 6550082 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 46 | 0.3 | 0.05 1357 | 6550083 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 67 | 0.3 | 0.05 1357 | 6550084 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 85 | 0.3 | 0.01 1357 | 6550085 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 94 | 0.3 | 0.01 1357 | 6550086 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 89 | 0.3 | 0.01 1357 | 6550087 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 17 | 0.3 | 0.01 1357 | 6550088 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 17 | 0.3 | 0.01 1357 | 6550090 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 62 | 0.82 | 0.1 13579 | 6550091 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 148 | 0.63 | 0.05 1358 | 6550092 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 162 | 0.63 | 0.01 1358 | 6550093 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 120 | 0.63 | 0.05 1358 | 6550094 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 94 | 0.63 | 0.05 1358 | 6550095 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 79 | 0.63 | 0.01 1358 | 6550096 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 31 | 0.63 | 0.01 1358 | 6550097 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 61 | 0.84 | 0.1 13586 | 6550098 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 60 | 0.84 | 0.05 1358 | 6550100 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 17 | 0.38 | 0.01 1358 | 6550101 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 22 | 0.38 | 0.01 1358 | 6550102 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 22 | 0.38 | 0.01 1359 | 6550103 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 34 | 0.38 | 0.01 1359 | 6550104 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 28 | 0.38 | 0.01 1359 | 6550105 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1359 | 6550106 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1359 | 6550107 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1359 | 6550110 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 31 | 0.38 | 0.01 1359 | 6550111 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 42 | 0.38 | 0.01 1359 | 6550112 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 29 | 0.38 | 0.01 1359 | 6550113 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 20 | 0.38 | 0.01 1359 | 6550114 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 0.38 | 0.01 1360 | 6550115 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 22 | 0.38 | 0.01 1360 | 6550116 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 21 | 0.38 | 0.01 1360 | 6550117 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 23 | 0.38 | 0.05 1360 | 6550120 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 58 | 0.38 | 0.05 1360 | 6550121 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 80 | 0.38 | 0.01 1360 | 6550122 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 0.38 | 0.05 1360 | 6550123 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 58 | 0.38 | 0.05 1360 | 6550124 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 43 | 0.38 | 0.05 1360 | 6550125 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 46 | 0.38 | 0.01 1360 | 6550126 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 23 | 0.38 | 0.05 1361 | 6550127 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 11 | 0.38 | 0.05 1361 | 6550130 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 38 | 0.38 | 0.01 1361 | 6550131 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 14 | 0.38 | 0.01 1361 | 6550132 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 13 | 0.38 | 0.01 1361 | 6550133 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 0 | 0.38 | 0.01 1361 | 6550134 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 0 | 0.38 | 0.01 1361 | 6550135 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 1 | 0.38 | 0.01 1361 | 6550136 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 12 | 0.38 | 0.01 1361 | 6550137 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 26 | 0.38 | 0.05 1361 | 6550140 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 66 | 0.38 | 0.01 1362 | 6550141 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 42 | 0.38 | 0.01 1362 | 6550142 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 25 | 0.38 | 0.05 1362 | 6550143 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 12 | 0.38 | 0.05 1362 | 6550144 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 31 | 0.38 | 0.01 1362 | 6550145 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 27 | 0.38 | 0.01 1362 | 6550146 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 34 | 0.38 | 0.01 1362 | 6550147 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 36 | 0.38 | 0.05 1362 | 6550148 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 36 | 0.38 | 0.01 1362 | 6550150 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 60 | 1.06 | 0.1 13629 | 6550151 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 186 | 1.06 | 0.05 1363 | 6550152 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 172 | 0.85 | 0.1 13631 | 6550153 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 177 | 0.85 | 0.1 13632 | 6550154 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 132 | 0.85 | 0.05 1363 | 6550155 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 60 | 0.85 | 0.01 1363 | 6550156 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.85 | 0.01 1363 | 6550157 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 1.27 | 0.15 1363 | 6550158 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 48 | 1.64 | 0.2 13637 | 6550160 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1363 | 6550161 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1363 | 6550162 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 16 | 0.38 | 0.01 1364 | 6550163 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 18 | 0.38 | 0.01 1364 | 6550164 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 23 | 0.38 | 0.01 1364 | 6550165 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 12 | 0.38 | 0.01 1364 | 6550166 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.05 1364 | 6550167 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.05 1364 | 6550168 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 24 | 0.38 | 0.01 1364 | 6550170 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 50 | 1.06 | 0.1 13647 | 6550171 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 119 | 1.06 | 0.1 13648 | 6550172 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 102 | 0.85 | 0.1 13649 | 6550173 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 145 | 0.85 | 0.1 13650 | 6550174 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 168 | 0.85 | 0.05 1365 | 6550175 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 90 | 0.85 | 0.05 1365 | 6550176 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 38 | 0.85 | 0.05 1365 | 6550177 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 75 | 1.27 | 1.9 13654 | 6550178 | | Barrel Swi | Eagle Claw | Fishing | Terminal T | 27 | 1.64 | 0.2 13655 | 6550180 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 2 | 0.37 | 0.01 1365 | 6550181 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 9 | 0.37 | 0.01 1365 | 6550182 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 15 | 0.37 | 0.01 1365 | 6550183 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 13 | 0.37 | 0.01 1365 | 6550184 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 4 | 0.37 | 0.01 1366 | 6550185 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 14 | 0.37 | 0.01 1366 | 6550186 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 16 | 0.4 | 0.01 1366 | 6550187 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 0 | 0.4 | 0.05 1366 | 6550188 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 0 | 0.4 | 0.01 1366 | 6550189 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.4 | 0.01 1366 | 6550190 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 0 | 0.4 | 0.01 1366 | 6550200 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 5 | 0.37 | 0.01 1366 | 6550201 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 15 | 0.37 | 0.01 1366 | 6550202 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 9 | 0.37 | 0.01 1366 | 6550203 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 9 | 0.37 | 0.01 1367 | 6550204 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 9 | 0.37 | 0.01 1367 | 6550205 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1367 | 6550206 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 11 | 0.37 | 0.01 1367 | 6550207 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.05 1367 | 6550208 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1367 | 6550209 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.37 | 0.01 1367 | 6550210 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 11 | 0.37 | 0.01 1367 | 6550220 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 70 | 0.43 | 0.01 1367 | 6550221 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 56 | 0.43 | 0.01 1367 | 6550222 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 31 | 0.43 | 0.01 1368 | 6550223 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 59 | 0.43 | 0.01 1368 | 6550224 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 36 | 0.43 | 0.01 1368 | 6550225 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 2 | 0.43 | 0.05 1368 | 6550226 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 15 | 0.43 | 0.05 1368 | 6550230 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1368 | 6550231 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1368 | 6550232 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 0 | 0.43 | 0.01 1368 | 6550233 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1368 | 6550234 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1368 | 6550235 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 7 | 0.43 | 0.01 1369 | 6550236 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 7 | 0.43 | 0.05 1369 | 6550237 | | Crane Swiv | Eagle Claw | Fishing | Terminal T | 7 | 0.43 | 0.01 1369 | 6550240 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1369 | 6550241 | | Crossline | Eagle Claw | Fishing | Terminal T | 11 | 0.43 | 0.01 1369 | 6550242 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1369 | 6550243 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1369 | 6550244 | | Crossline | Eagle Claw | Fishing | Terminal T | 11 | 0.43 | 0.01 1369 | 6550245 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1369 | 6550246 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1369 | 6550247 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1370 | 6550248 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1370 | 6550250 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1370 | 6550251 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1370 | 6550252 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1370 | 6550253 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.01 1370 | 6550254 | | Crossline | Eagle Claw | Fishing | Terminal T | 23 | 0.43 | 0.01 1370 | 6550255 | | Crossline | Eagle Claw | Fishing | Terminal T | 14 | 0.43 | 0.01 1370 | 6550256 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.43 | 0.05 1370 | 6550257 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1370 | 6550258 | | Crossline | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1371 | 6550260 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 22 | 0.44 | 0.01 1371 | 6550261 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 10 | 0.44 | 0.01 1371 | 6550262 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 36 | 0.44 | 0.01 1371 | 6550263 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 29 | 0.44 | 0.01 1371 | 6550264 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1371 | 6550265 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 24 | 0.44 | 0.05 1371 | 6550270 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1371 | 6550271 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.01 1371 | 6550272 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 13 | 0.44 | 0.01 1371 | 6550273 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 19 | 0.44 | 0.05 1372 | 6550274 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 12 | 0.44 | 0.05 1372 | 6550275 | | Dual Lock | Eagle Claw | Fishing | Terminal T | 31 | 0.44 | 0.05 1372 | 6550280 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 15 | 0.33 | 0.02 1372 | 6550281 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 12 | 0.33 | 0.02 1372 | 6550282 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 2 | 0.33 | 0.02 1372 | 6550283 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 14 | 0.33 | 0.02 1372 | 6550284 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 4 | 0.33 | 0.01 1372 | 6550285 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 20 | 0.33 | 0.01 1372 | 6550286 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 0 | 0.33 | 0 13729 | 6550287 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 0 | 0.33 | 0 13730 | 6550288 | | Split-Ring | Eagle Claw | Fishing | Terminal T | 0 | 0.33 | 0 13731 | 6550300 | | Snap Swive | Eagle Claw | Fishing | Terminal T | 60 | 1.47 | 0.3 13732 | 6550302 | | "Hook | Swivel & S | Eagle Claw | Fishing | Terminal T | 0 | 1.47 | 0 13733 | 6550305 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 0 | 0.89 | 0.15 1373 | 6550306 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 0 | 1.3 | 0.35 1373 | 6550307 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 32 | 1.45 | 0.5 13736 | 6550308 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 0 | 1.85 | 0.5 13737 | 6550310 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 19 | 1.23 | 0.35 1373 | 6550311 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 6 | 1.63 | 0.3 13739 | 6550312 | | Sinker Ass | Eagle Claw | Fishing | Terminal T | 15 | 1.7 | 0.15 1374 | 6550313 | | "Sinker As | Split | Pinch | Worm | Bass 62pcs | Eagle Claw | Fishing | Terminal T | 0 | 1.47 | 0 13741 | 6550320 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 92 | 0.34 | 0.1 13742 | 6550321 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 102 | 0.34 | 0.1 13743 | 6550322 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 90 | 0.34 | 0.15 1374 | 6550323 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 17 | 0.34 | 0.1 13745 | 6550324 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 23 | 0.34 | 0.1 13746 | 6550325 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 58 | 0.34 | 0.1 13747 | 6550326 | | Egg Sinker | Eagle Claw | Fishing | Terminal T | 76 | 0.34 | 0.1 13748 | 6550330 | | Removable | Eagle Claw | Fishing | Terminal T | 95 | 0.34 | 0.05 1374 | 6550331 | | Removable | Eagle Claw | Fishing | Terminal T | 82 | 0.34 | 0.05 1375 | 6550332 | | Removable | Eagle Claw | Fishing | Terminal T | 57 | 0.34 | 0.1 13751 | 6550333 | | Removable | Eagle Claw | Fishing | Terminal T | 90 | 0.34 | 0.1 13752 | 6550334 | | Removable | Eagle Claw | Fishing | Terminal T | 62 | 0.34 | 0.1 13753 | 6550335 | | Removable | Eagle Claw | Fishing | Terminal T | 0 | 0.34 | 0.1 13754 | 6550336 | | Removable | Eagle Claw | Fishing | Terminal T | 0 | 0.34 | 0.1 13755 | 6550340 | | Round Spli | Eagle Claw | Fishing | Terminal T | 100 | 0.34 | 0.1 13756 | 6550341 | | Round Spli | Eagle Claw | Fishing | Terminal T | 96 | 0.34 | 0.1 13757 | 6550342 | | Round Spli | Eagle Claw | Fishing | Terminal T | 0 | 0.34 | 0 13758 | 6550343 | | Round Spli | Eagle Claw | Fishing | Terminal T | 108 | 0.34 | 0.1 13759 | 6550344 | | Round Spli | Eagle Claw | Fishing | Terminal T | 84 | 0.34 | 0.25 1376 | 6550345 | | Round Spli | Eagle Claw | Fishing | Terminal T | 86 | 0.34 | 0.05 1376 | 6550346 | | Round Spli | Eagle Claw | Fishing | Terminal T | 93 | 0.34 | 0.15 1376 | 6550347 | | Round Spli | Eagle Claw | Fishing | Terminal T | 84 | 0.34 | 0.05 1376 | 6550390 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13764 | 6550391 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13765 | 6550395 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13766 | 6550396 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13767 | 6550397 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13768 | 6550398 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 1.1 | 0 13769 | 6550400 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13770 | 6550401 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13771 | 6550405 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13772 | 6550406 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13773 | 6550407 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.1 | 0 13774 | 6550408 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.52 | 0 13775 | 6550409 | | "Spring Fl | Eagle Claw | Fishing | Terminal T | 0 | 1.06 | 0 13776 | 6550410 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 54 | 0.81 | 0.02 1377 | 6550411 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 21 | 0.81 | 0.02 1377 | 6550412 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 45 | 0.81 | 0.03 1377 | 6550413 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 33 | 0.81 | 0.02 1378 | 6550414 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13781 | 6550415 | | "Slip Floa | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13782 | 6550420 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13783 | 6550421 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13784 | 6550422 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13785 | 6550423 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13786 | 6550424 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13787 | 6550425 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 0.81 | 0 13788 | 6550430 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13789 | 6550431 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13790 | 6550432 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13791 | 6550433 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13792 | 6550434 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13793 | 6550435 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13794 | 6550440 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13795 | 6550441 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13796 | 6550442 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13797 | 6550443 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13798 | 6550444 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13799 | 6550445 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13800 | 6550446 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13801 | 6550447 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.01 | 0 13802 | 6550450 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.27 | 0 13803 | 6550451 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.27 | 0 13804 | 6550452 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.27 | 0 13805 | 6550453 | | "Snap-On F | Eagle Claw | Fishing | Terminal T | 0 | 1.27 | 0 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Updated

 

 

Only 1 item from that shows, and ideas?

 

Thanks

[Guest]

look at the end of each line, per the documentation, you need an EOREOR for the very last column

[Guest]

i would be inclined to the price break is the problem

 

I also have Price_break 1.11.3 installed which could be causing a conflict

Ray

<{POST_SNAPBACK}>

[Guest]

Hello Community,

 

I have a problem with the froogle-export:

 

When I export the Froogle-txt with "Create Froogle tab-delimited .txt file in temp dir", I get a complete list, where the first three rows (product_url name description) are empty and the currency-row shows USD instead my standard: EUR. I don?t know how to fix this problem.

 

Could somebody help me please?

 

Regards,

Alex T.

Germany

[Guest]

take a look at your product list in the admin, matching up the product model# with the product model# from the easypopulate text file.

[Guest]

Sorry, but I don?t understand.

 

Where should I take a look at your product list in the admin, matching up the product model# with the product model# from the easypopulate text file.

 

Could you please eyplain me what to do?

 

It?s the first time that I installed a OScommerce and (as a designer) I?m happy that I got it working until here but EP-Froogle-Export won?t work.

 

Thx a lot for help

 

Regards,

Alex T.

Germany

[Banagor]

Hey everyone,

 

I still can't get my easypopulate.php to work. :/ Still on a fresh install. I still get a parse error in line 231. :/

 

Anyone have any experience with this? It would be nice to be able to see the darn thing. :/

 

Thanks.

[Guest]

did you read thru and set document root to suggest change?

did you change the semicolon to tab delimited:

did you setup the proper temp dir and file permissions?

what is the parse error? without more info we are twiddling our thumbs, as people sometimes use versions from here and elsewhere.

[Banagor]

Hey Mibble,

 

Thanks for answering. I posted about this yesterday but this thread seems to get swamped a lot. :)

 

Here's a recap, and yeah, I've RTFM. But if I've overlooked something, it's because this is all new to me. :)

 

It's OSCommerce 2.2 fresh install.

Easypopulate 2.7a I think?

 

I don't have a /catalog/temp because I don't really know where my catalog is. Instead, I made a /temp folder in the root directory and gave it 777 chmod.

 

The error is the following, when attempting to access the easypopulate.php file online:

 

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/public_html/goodhouseplans/admin/easypopulate.php on line 231

 

Any help is appreciated. :) Thank you.

[Banagor]

Make that EZPouplate 2.76 :)

 

Where do I set document root? I changed the temp directory in easypopulate.php to /temp (for temp 1 and 2), and I also went through to look at other changes necessary but couldn't find any I really wanted to touch without knowing what I was doing...mostly beacause I have no idea what they are really configuring yet.

 

As to tabs, I didn't touch that. It's set to \t right now and since I can't even sett easypopulate.php working, I figured I'd mess around with how to upload something when it's actually working? :)

[PaulyB]

Dear John

 

Thank you very much for your guidance, I am well on the way now to uploading what I want.

 

Many thanks for your time

 

Paul

[Banagor]

I still can't get it. Been trying all morning again. I still get the line error 231 no matter what I do.

 

Rundown again:

 

OSC 2.2

EZP: 2.76

 

Created /temp in root directory of OSC site and set to 777

 

Edited easypopulate.php to do:

 

set temp directory 1 and 2 to /temp

 

Set froogle (even though I don't have a froogle account yet and I'm not sure what froogle really is apart from google shop online or something) to my URL (which works - tested both urls to make sure they work nicely before I set them in the config).

 

Uploaded easypopulate.php and easypopulate_functions.php to /public_html/goodhouseplans/admin

 

I even tried the easypopulate_functions-older.php file, renaming it to easypopulate_functions.php. That didn't work either so I reset it to the "new" functions file.

 

Anything else I missed? Any files I should upload? Any configs I should figure out? I left seperators at \t since it's the default and I haven't even gotten to the stage where I can upload an excel file yet anyway.

 

This is the error, again:

 

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/public_html/goodhouseplans/admin/easypopulate.php on line 231

 

Nothing I do fixes it and line 231 is the following:

 

$epdlanguage_query = tep_db_query("select languages_id, name from " . TABLE_LANGUAGES . " where code = '" . DEFAULT_LANGUAGE . "'");

 

I checked that my default is English (it is). Nothing was modified on the OSC install. It's absolutely fresh without any changes whatsoever. I haven't even edited the admin email lines yet. Absolutely nothing was touched.