Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy populate gifs


maykeltje

Recommended Posts

Hi everybody. I've tried my easypopulate with I think 100 produkts and it worked fine. So I expanded my excel sheet with more products. When finished I tried to upload the sheet. But it gave me an duplicate error. I tried to upload only the first 100 products but sae problem. What coud be wrong? The file its all abbout you can find here Klick here for the ep txt

 

 

 

the error easy populate gives is the following:

 

File uploaded.

Temporary filename: /tmp/phpkuF6Gp

User filename: ep2005compleet.txt

Size: 339219

| 240 002 54 | 240 000 81 | Slangklem | slanklem 2 | | | | | 0.9 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active Updated

| 240 002 03 | 240 000 81 | Slangklem | slanklem 3 | | | | | 0 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active Updated

| 240 001 62 | 240 000 81 | Slangklem | slangklem | | | | | 0.85 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active Updated

| 240 001 01 | 240 000 81 | Slangklem | Slangklem | | | | | 0.8 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active Updated

| 270 280 00 | geka spuit | spuitnozzl | Geka Spuit | | | | | 13.95 | 0.00 | | | 0 | | Lage druk | lage druk | | BTW Hoog | Active !New Product!

1062 - Duplicate entry '6-4' for key 1

 

INSERT INTO categories_description( categories_id, language_id, categories_name ) VALUES ( 6, '4', 'Geka Tule' )

 

[TEP STOP]

Link to comment
Share on other sites

Hi everybody. I've tried my easypopulate with I think 100 produkts and it worked fine. So I expanded my excel sheet with more products. When finished I tried to upload the sheet. But it gave me an duplicate error. I tried to upload only the first 100 products but sae problem. What coud be wrong? The file its all abbout you can find here Klick here for the ep txt

the error easy populate gives is the following:

 

You already have a database entry for categories_id 6 and language_id 4.

 

Did you use a new speadsheet or just add additional entries to the previous one?

 

Remove the products you have already added and try and run the spreadsheet again.

 

S

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

You already have a database entry for categories_id 6 and language_id 4.?

 

Did you use a new speadsheet or just add additional entries to the previous one?

 

Remove the products you have already added and try and run the spreadsheet again.

 

S

 

I've deleted all the categories and products via my mysql. Maybe it did go wrong there?

 

Now i deleted all products via admin and now i get the following message:

 

File uploaded.

Temporary filename: /tmp/phpof7trx

User filename: ep2005compleet.txt

Size: 339219

| 240 002 54 | 240 000 81 | Slangklem | slanklem 2 | | | | | 0.9 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active !New Product!

| 240 002 03 | 240 000 81 | Slangklem | slanklem 3 | | | | | 0 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active !New Product!

| 240 001 62 | 240 000 81 | Slangklem | slangklem | | | | | 0.85 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active !New Product!

| 240 001 01 | 240 000 81 | Slangklem | Slangklem | | | | | 0.8 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active !New Product!

| 270 280 00 | geka spuit | spuitnozzl | Geka Spuit | | | | | 13.95 | 0.00 | | | 0 | | Lage druk | lage druk | | BTW Hoog | Active !New Product!

| 270 280 03 | 270 280.jp | waterkoppe | 1 1/2\' | | | | | 5 | 0.00 | | | 0 | | Lage druk | water aans | Geka Tule | BTW Hoog | Active !New Product!

| 250 280 38 | 250 280 38 | Geka afdic | 3/8\" a | | | | | 0.28 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active !New Product!

| 250 280 12 | 250 280 38 | Geka afdic | 1/2" af | | | | | 0.28 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active !New Product!

| 250 280 11 | 250 280 38 | Geka afdic | 1"afdic | | | | | 0.3 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active !New Product!

| 250 280 34 | 250 280 38 | Geka afdic | 3/4\"af | | | | | 0.3 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active !New Product!

| 250 280 11 | 250 280 38 | Geka afdic | 1 1/4 " | | | | | 0.44 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active !New Product!

| 250 280 38 | 250 280 38 | Geka afdic | 1 1/2" | | | | | 0.5 | 0.00 | | | 0 | | Lage druk | water aans | Geka Acces | BTW Hoog | Active Updated

| 240 000 81 | 240 000 81 | Slangklem | Slanklem | | | | | 0.75 | 0.00 | | | 0 | | Lage druk | water aans | Slangen kl | BTW Hoog | Active !New Product!

1062 - Duplicate entry '7-4' for key 1

 

INSERT INTO categories_description( categories_id, language_id, categories_name ) VALUES ( 7, '4', 'Geka schroefdraad koppelingen' )

 

[TEP STOP]

Link to comment
Share on other sites

Maybe anybody nows it now. When i upload with easypopulate he stops. Then when i delete the things I?ve uploaded and do the same file again with ep he goes further. And the counting error goes as 9-4 then 10-4 then 11-4.

 

How can I quick change something to resolve this problem

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...