Easy Populate 1.2.5.4 support

[grayceworks]

I may be misunderstanding what I'm reading in the instructions, but will removing items from the downloaded product file remove them from my database?

I have this installed, but have been afraid to try it because it took forever to get my database fixed last time I tried to upload products.

Basically I need to know if I'm understanding the functions correctly.

I downloaded a "complete" file.

I made changes in excel, and saved as the same type of txt file as I downloaded.

If I upload the changed file, does it overwrite existing products with the changed items of the same model number? or does it upload everything in the file as new items? I don't want duplicates.

By the same token, if I upload a file that only contains new items, and does not have existing store items in it, will it delete items that are not in the new file?

I just don't want to mess stuff up... lol

Thanks!

[Scrat]

The model number is unique to that product, so if you download a 'Complete' download and then alter one or more products in excel and upload the new file it will update all the records in the file whether they are changed or not. Thus it will give you a 'update' against the imported product. If you just upload a new product this will not remove any products from your database it will just import the new product.

Too delete a product from the database in column marked 'v_status' change from 1 to 9 and this will delete the product using the upload file.
But alwasys back your database up first before uploading new products.

[grayceworks]

Thanks... That's what I was trying to figure out.

[yellowdaises]

it looks like the query is missing an end quote
the query reads
products_quantity="20, products_price_w="11.4900"
where it ought to be
products_quantity="20", products_price_w="11.4900"

hope that helps you out!

That's awesome. I'm going to check that out right now... Great eyes !!! :)

[RSprinkel]

Ok I am NOT a happy camper, LOL.

I just spent every bit of 3 hours adding 87 items to excel, saved the file as text file required. I then went into the admin section and hit browse for upload. Went to the file and then clicked "Insert into Db". It showed the files as being uploaded and once completed I went to the test site and NOTHING is showing.

I had 3 items already in the db prior to doing this and they are the only 3 showing.

At the bottom of the upload I got this message and I am NOT sure if it is the reason why nothing is showing.

Next to last line reads:

UPDATED! - Model: 1:64 SCale | /items/Sr | 1999 Revel | 1999 Revel | | 19 | 0001-01-01 | 0001-01-01 | 30 | 0 | | 2/22/2007 | 3 | Revell | Nascar | Earnhardt | 1:64 Scale | | | | | --none-- | 1 |

Last Line reads:

SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

Any help on this WOULD be much appreciated.

Thanks in Advance.

RSprinkel

[Ryk]

The only obvious thing to me is that you don't have the EOREOR column

[Scrat]

Check your txt file that it had categories for the new products as the error is telling you that this line had no category for that product/model

[omfgsignmeup]

I've been forwarded to this thread because I asked how to populate a ZenCart site using a .tsv (tab separated values) file. Now, I don't believe this is compatible with Easy Populate but I could be wrong? If not, is it at all possible to import the stocklist.tsv file into Microsoft Excel then export it as a .txt file ready to import with Easy Populate?

I really need to know this and soon!

I have a client looking for answers. I want to use ZenCart because I'm familiar with it and it’s easy to edit!

Thanks!

[langer]

I've been forwarded to this thread because I asked how to populate a ZenCart site using a .tsv (tab separated values) file. Now, I don't believe this is compatible with Easy Populate but I could be wrong? If not, is it at all possible to import the stocklist.tsv file into Microsoft Excel then export it as a .txt file ready to import with Easy Populate?

Easy Populate uses tab separated files - the file extension is irrelevant, and is used by applications to easily identify their accepted files - it has no bearing on the actual file format.

You will need to format any file you use to conform to the column headings and the explicit end of row marker (EOREOR) expected by Easy Populate.

[RSprinkel]

Ryk,

In reply to yours, I am not sure as to why it didnt show the EOREOR in the ZenCart Admin section, but trust me all 87 lines have it. Here is a line direct from my excel file

[FONT=Arial]1:64 SCale[/FONT][FONT=Arial]/items/Jim 028.jpg[/FONT][FONT=Arial]1999 W.C. #3 Car, Stats and Standings Book[/FONT][FONT=Arial]1999 Winners Circle. #3 Dale Earnhardt Sr Chevrolet w/Stats and Standings Book[/FONT][FONT=Arial][/FONT][FONT=Arial]15[/FONT][FONT=Arial]0001-01-01[/FONT][FONT=Arial]0001-01-01[/FONT][FONT=Arial]16[/FONT][FONT=Arial][/FONT][FONT=Arial]2/22/2007[/FONT][FONT=Arial]2/22/2007 11:46[/FONT][FONT=Arial]1[/FONT][FONT=Arial]Winners Circle[/FONT][FONT=Arial]Nascar[/FONT][FONT=Arial]Earnhardt Sr[/FONT][FONT=Arial]1:64 Scale[/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial][/FONT][FONT=Arial]--none--[/FONT][FONT=Arial]1[/FONT][FONT=Arial]EOREOR[/FONT]

Scrat,

Well the first 87 lines I entered are all in the same categories/Sub categories as the ones that were already in the database, nothing different, nothing added.

I am wondering if one of the tables that was filled in should be blank when added and thats the columnh for date added. AS that has a Time in it as well. Alot of the columns that was going to have the same data in I just dragged and then Filled/Down to avoid alot of typing and possibly making mistakes.


omfgsignmeup,

Wish I could help ya, LOL. I know nothing of the .tsv you speak of. Good Luck

Thanks for your replies and I hope someone can help me out on this one. As I only have about 3000 sq ft of Store of Items to add

RSPrinkel