EasyPopulate 4.0 Support Thread

[adb34]

Bloody hell you have written a lot. I will take a copy, read it tonight and get back to you.

[mc12345678]

Bloody hell you have written a lot. I will take a copy, read it tonight and get back to you.

Had 2 options. Write a little about nothing, or provide information on what I think I understand. :) either way probably did or would have missed the mark. :)

[adb34]

Had 2 options. Write a little about nothing, or provide information on what I think I understand. :) either way probably did or would have missed the mark. :)

I have put a response together, would you like me to MP you, or put it in here?

[mc12345678]

I have put a response together, would you like me to MP you, or put it in here?

If it's a hate message or otherwise doesn't meet the general posting policy, better via PM. If it is something to discuss the operation of EP4, others are likely to gain something from it and could/should be posted here. :)

[adb34]

If it's a hate message or otherwise doesn't meet the general posting policy, better via PM. If it is something to discuss the operation of EP4, others are likely to gain something from it and could/should be posted here. :)

Not worth the effort to send a hate message.

The first bit about the missing ‘Tax Class’ and ‘products Price’ my own stupid fault and I have fixed that.

Sorry for the missing understanding. It is terminology that I used when I was a Network manager here in the UK.

I did a backup of my store and with problems beyond my control I had to re-build my store and used that backup to populate my new store.
When you go admin->catalog->CATEGORIES / PRODUCTS – TOP you are presented with column titles of ‘ID’ ‘Categories/Products’, ‘Model’, ‘Price/Special/Sale’, ‘Quantity’, ‘Status’, ‘Sort’ and ‘Action’.

If you have anything written in ‘Categories/Products’ and value in ‘Quantity’ for example 63 of 63, then all of the ‘Categories/Products’ are backed up so that when you need to upload the backup all is put back so you will get ‘Categories/Products’ and value in ‘Quantity’ 63 of 63 and all is well.

However, if you have one product ‘Out of stock the ‘Quantity’ for the ‘Categories/Products’ will display 62 of 63. Then after a backup and you want to use that backup, the ‘Out of Stock’ product is not there and the value in ‘Quantity’ will be 62 of 62. Therefore, the ‘out of stock’ product or then products will be lost (not backed up).

Also, if you have ‘set up’ the drill down of ‘Categories/Products’ for example Shoes->color->blue->sizes but do not put any products under sizes, then the ‘Categories/Products’ sizes is not backed up, so that when you use your backup the ‘Categories/Products’ sizes will not be there.

I hope this helps you.

[mc12345678]

Not worth the effort to send a hate message.

The first bit about the missing ‘Tax Class’ and ‘products Price’ my own stupid fault and I have fixed that.

Sorry for the missing understanding. It is terminology that I used when I was a Network manager here in the UK.

I did a backup of my store and with problems beyond my control I had to re-build my store and used that backup to populate my new store.
When you go admin->catalog->CATEGORIES / PRODUCTS – TOP you are presented with column titles of ‘ID’ ‘Categories/Products’, ‘Model’, ‘Price/Special/Sale’, ‘Quantity’, ‘Status’, ‘Sort’ and ‘Action’.

If you have anything written in ‘Categories/Products’ and value in ‘Quantity’ for example 63 of 63, then all of the ‘Categories/Products’ are backed up so that when you need to upload the backup all is put back so you will get ‘Categories/Products’ and value in ‘Quantity’ 63 of 63 and all is well.

However, if you have one product ‘Out of stock the ‘Quantity’ for the ‘Categories/Products’ will display 62 of 63. Then after a backup and you want to use that backup, the ‘Out of Stock’ product is not there and the value in ‘Quantity’ will be 62 of 62. Therefore, the ‘out of stock’ product or then products will be lost (not backed up).

Also, if you have ‘set up’ the drill down of ‘Categories/Products’ for example Shoes->color->blue->sizes but do not put any products under sizes, then the ‘Categories/Products’ sizes is not backed up, so that when you use your backup the ‘Categories/Products’ sizes will not be there.

I hope this helps you.

So, issues described that remain a problem are on the store front, and store front only?

One thing before possibly describing what's going on, again want to say that EP4 is not exactly a backup tool... It's original purpose appears to have been to make import of bulk product such as those provided by a "vendor" easy and quick, then it changed a little to make it easy to manipulate the data in the database in a bulk manner (increase/decrease all prices by a certain amount), but not strictly as a backup tool (there are other more dedicated programs to do that). So, that PA made. :)

The export of the "Full product data" will include all active (v_status = 1) and inactive (v_status = 0) product. The same is true if using the dropdowns at the top of the screen provided the last one (status) is set to "All".

On import, all rows that meet the primary key criteria (default: products_model) will be imported. Based on the settings in the admin configuration->Easy Populate 4 at the setting Make Zero Qty Products Inactive: When uploading, make the status Inactive for products with zero qty (default: false). If this has been changed to true, then on upload of the out-of-stock product, the product will become deactivated and the total quantity of product per category will decrease.

Now, the default for that setting is false, which means that product with zero quantity are to be uploaded and remain "active" to the store visitor(s). Mind you, there is one "issue" discussed over the last couple of pages that relates to populating some other areas of the database (still need to write the other two solutions I have considered for "restoring" from that situation) such as manufacturers. The described issue though seems to be something a little different.

See if setting the Make Zero Qty Products Inactive option to false resolves your issue, otherwise need to find out more about your products table I think. If it does not resolve the issue, could you (maybe again?) post the settings you have for EP4?

[adb34]

So, issues described that remain a problem are on the store front, and store front only?.......

No this problem is in the back office.

I will investigate and get back. It is a pity that EP4 is not for a store backup, it would make a perfect package to do both bulk upload and backup.