EasyPopulate 4.0 Support Thread

AWESOME!!! Chadd, I love you!!! This mod rules! :D

Anybody else that wants to do this, simply go to Configuration/Easy Populate 4/User Defined Products Fields and add: products_id (not v_products_id).

Chargin, all you have to do is get EP to provide you with product ID (see above). Then you can go export the Ceon URI table via phpMyAdmin (as you describe above... I recommend you export as Open Document Spreadsheet to stay compatible with EP4).

Once you have both files open (your phpMyAdmin and your EP4) sort both files by ID# and line them up. Edit the URIs, then using your phpMyAdmin file as template, import the edited data.

Good luck!

As much as I hate to admit it, I am stuck at a simple point in using EP 4. I have it installed and I downloaded a product to learn on. I want to change the price from $10.99 to $11. I open in Excel, change the price and save the file. I save it as the same name it was originally called PriceQuantity-EP2013Jul01-161941.csv. I had changed the configuration of my Easy Populate 4 in the configuration to the name of my admin directory for Zen Cart, let's call it bigbob/ Then I tried to download the test product into my desktop then opened Excel and changed the price from $10.99 to $11. I saved it with the original name and as a .csv file, and used Easy Populate 4 in my admin panel to upload it. It did go to bigbob/ but that is where it stays. So, I think I don't have the right destination. I have looked in a variety of places (including the WIKI) but I think I don't have it configured to save in the right place, I think it needs to be more specific than just the name of my admin file. I do have the right model number on it, I did download it as a model/price/quantity file. I am using Zen Cart v 1.5.1 Please tell me what the address should be to load it back to my admin area with the changed price on it. Thanks.

Never mind the above, I tried out Apsona Shop Admin and got it going right away. I will be using that one, so I don't need the above question answered.

Hello,
In the Italian language there are problems to import a character, è, ù, ì, ò, etc..
For the moment I solved it by replacing with my management software.
The problem of easypopulate4.0 still exists or has been resolved?
sorry for my english.

Hi I am trying to work out if this mod will do what I want before I install. I have read through this full thread and am still confused. I am using ZC 139h and stock by attributes. will this mod allow me to update the product quantities for each attribute. For example I have product 1145 available in small med and large. I want to be able to update the quantities from a suppliers csv file. I am confused by the need to have unique product ids. In the database the table products just shows the total stock combined. There is also another table for stock with attributes stock but I don't know how to match these tables.

propster:

Hi I am trying to work out if this mod will do what I want before I install. I have read through this full thread and am still confused. I am using ZC 139h and stock by attributes. will this mod allow me to update the product quantities for each attribute. For example I have product 1145 available in small med and large. I want to be able to update the quantities from a suppliers csv file. I am confused by the need to have unique product ids. In the database the table products just shows the total stock combined. There is also another table for stock with attributes stock but I don't know how to match these tables.

Hi,

I have not used the stock by attribute mod. If this mod uses custom tables to track stock, then I don't think EP4 (or any EP version) will help.

Perhaps another zenner has an answer or can suggest another mod.

EP4 uses the products_model as it's main key to link the various databases. If you don't use products_model numbers, then EP4 won't work for you...

-chadd

brancasalvo:

Hello,
In the Italian language there are problems to import a character, è, ù, ì, ò, etc..
For the moment I solved it by replacing with my management software.
The problem of easypopulate4.0 still exists or has been resolved?
sorry for my english.

Hi Bran,

If you could create a CSV file for me with your full language represented, I could do some testing for you. Note that your database collation can affect how character data is stored.

be sure to zip your CSV file before attaching it. Give me a dozen products or so. Also, which mod are you using for Italian?

-chadd

chadderuski:

Hi,

I have not used the stock by attribute mod. If this mod uses custom tables to track stock, then I don't think EP4 (or any EP version) will help.

Perhaps another zenner has an answer or can suggest another mod.

EP4 uses the products_model as it's main key to link the various databases. If you don't use products_model numbers, then EP4 won't work for you...

-chadd

So Propster, as written, no it will not import to Stock by attributes.

It would require a little more work. The Stock By Attributes table does (the version I'm using) include a reference back to the product id, which is also in the products table. Couple that information with the products_model info and you have references to the data that you need in the stock by attributes table. Thing is that table works a lot like (well basically is) the attributes table does, in that there are multiple entries tied to a single object. One of the differences/difficulties is that the data stored for a single stocked item (all the associated attributes) is not the same for all versions of Stock By Atttributes if I am correct. So any "manual" or instructions related to that portion may not be consistent across all versions. Being possible, I would say yes. Quick and easy, I would say relatively no.

But a start would be to look through some of the other import/export functions that work similarily and identify what information is needed to work both directions (import/export). And then carry on. It does seem that the code is robust with the various types of export reports, so this would just be one more report type.

Oh yes, the total # of items would be affected by EP 4 or others, but stock by attributes has it's own quantities and depending again on the installed version, the total may get reset or other things may change depending on how the SBA works, but this mod does not currently interface with the SBA table.

mc12345678:

So Propster, as written, no it will not import to Stock by attributes.

It would require a little more work. The Stock By Attributes table does (the version I'm using) include a reference back to the product id, which is also in the products table. Couple that information with the products_model info and you have references to the data that you need in the stock by attributes table. Thing is that table works a lot like (well basically is) the attributes table does, in that there are multiple entries tied to a single object. One of the differences/difficulties is that the data stored for a single stocked item (all the associated attributes) is not the same for all versions of Stock By Atttributes if I am correct. So any "manual" or instructions related to that portion may not be consistent across all versions. Being possible, I would say yes. Quick and easy, I would say relatively no.

But a start would be to look through some of the other import/export functions that work similarily and identify what information is needed to work both directions (import/export). And then carry on. It does seem that the code is robust with the various types of export reports, so this would just be one more report type.

Oh yes, the total # of items would be affected by EP 4 or others, but stock by attributes has it's own quantities and depending again on the installed version, the total may get reset or other things may change depending on how the SBA works, but this mod does not currently interface with the SBA table.
Wow thanks for the speedy response. So basically stock with attributes creates a new table in the database. what I am looking for is a method of linking the entries in this table with the product discription so that i can update the quantities from the inventory supplied. I don't mind creating a lookup table in excell to achieve this. I am just looking for a way to update quantities without having to go through the admin and enter the information manually

propster:

Wow thanks for the speedy response. So basically stock with attributes creates a new table in the database. what I am looking for is a method of linking the entries in this table with the product discription so that i can update the quantities from the inventory supplied. I don't mind creating a lookup table in excell to achieve this. I am just looking for a way to update quantities without having to go through the admin and enter the information manually

Perhaps Chadster can help with the "format" or setup needed within the program, but looking at the Stock by Attributes table in my database (Table Prefix)products_with_attributes_stock, I have 5 columns:
Stock_id (This is used specifically to identify a unique item's stock),
products_id (Which ties back to the (Table Prefix)products table),
stock_attributes (Which identifies which one or more attributes are associated with the stock_id),
quantity (The total number of items that match the stock_attributes for this product_id and stock_id), and
sort (supposedly to be used to sort the particular stock_id when viewing the products_id, though I don't know if or when that is enforced).

So, perhaps the easiest way to implement this is to only be able to deal with existing items that have a stock_id and not to have to add a new one attribute to an item.

In my list, I have a number for a products_id, and one or more numbers in the stock_attributes, these numbers correspond back to the product itself (which to use this mod requires a model number) and a designated attribute (red, black, whatever you have chosen) that is listed in the (Table Prefix)products_attributes table. So, there are ties back to each of those attributes. By exporting the (table prefix)products_with_attributes_stock table substituting the applicable product name (or model number as desired/needed) and the applicable attribute, the user (you) can intelligently understand what product is being referenced. Include in that output the stock_id and the quantity as a minimum, then when importing the data, (going back to probably using the model number) with the stock_id in the downloaded data, the upload is quite easy because there is only one item in the table that has that stock_id; however, it may also be possible (less likely for a user to make an error) to use the model number and the associated attributes to find in the table the one row that has that product_id and only that one attribute combination (it is possible though not desired to have a product_id that has less attributes identified than those that would be sold, but I think that comes through attempting to incorrectly modify the number of attributes while adjusting quantities at the same time, ie. user error. :) )

That's the basic flow/thought process that I see, and although I have just yesterday tried to update a single item using the Full-EP file format, I did look through a bit of the main controller for EP 4 to see what I might need to do to ensure it worked. I would think that Chadster could identify the areas that would need to be worked in to add the above functionality.

mc12345678:

Perhaps Chadster can help with the "format" or setup needed within the program, but looking at the Stock by Attributes table in my database (Table Prefix)products_with_attributes_stock, I have 5 columns:
Stock_id (This is used specifically to identify a unique item's stock),
products_id (Which ties back to the (Table Prefix)products table),
stock_attributes (Which identifies which one or more attributes are associated with the stock_id),
quantity (The total number of items that match the stock_attributes for this product_id and stock_id), and
sort (supposedly to be used to sort the particular stock_id when viewing the products_id, though I don't know if or when that is enforced).

So, perhaps the easiest way to implement this is to only be able to deal with existing items that have a stock_id and not to have to add a new one attribute to an item.

In my list, I have a number for a products_id, and one or more numbers in the stock_attributes, these numbers correspond back to the product itself (which to use this mod requires a model number) and a designated attribute (red, black, whatever you have chosen) that is listed in the (Table Prefix)products_attributes table. So, there are ties back to each of those attributes. By exporting the (table prefix)products_with_attributes_stock table substituting the applicable product name (or model number as desired/needed) and the applicable attribute, the user (you) can intelligently understand what product is being referenced. Include in that output the stock_id and the quantity as a minimum, then when importing the data, (going back to probably using the model number) with the stock_id in the downloaded data, the upload is quite easy because there is only one item in the table that has that stock_id; however, it may also be possible (less likely for a user to make an error) to use the model number and the associated attributes to find in the table the one row that has that product_id and only that one attribute combination (it is possible though not desired to have a product_id that has less attributes identified than those that would be sold, but I think that comes through attempting to incorrectly modify the number of attributes while adjusting quantities at the same time, ie. user error. :) )

That's the basic flow/thought process that I see, and although I have just yesterday tried to update a single item using the Full-EP file format, I did look through a bit of the main controller for EP 4 to see what I might need to do to ensure it worked. I would think that Chadster could identify the areas that would need to be worked in to add the above functionality.

Also take a look at a post I put up earlier on a different thread. It takes you to one of the other threads about one/two versions of SBA that are recognized out there. http://www.zen-cart.com/showthread.php?166928-Stock-by-Attributes-5-0-Beta-%28for-v1-5-0%29&p=1208146#post1208146

I implemented the method I described and was able to create SQL that I could use/copy into the admin panel and update the table(s) with the desired information. It is dirty sort of like what you were referring to (using a reference table or something) and is somewhat the foundation to EP, but it also does not afford any type of real checks so would want to implement cautiously. (That means BACKUP, BACKUP, BACKUP and test/check after taking action.)

Hey guys,

There MAY be some small hope to do this. But, believe me, the attribute importing code is quite complex.

But, look at the DETAILED attribute export. This is a "special" file as it is one-to-one. When you export this file and look at the first columns, and examine the import code, you see that this is a very basic key lookup and replace loop.

That is why I made the creation of the values different than the updating.

I would be possible to modify the DETAILED attribute export code to also incorporate the SBA tables in a similar manner, and then do the same for the Import code.

Unfortunately, I don't have time right now. Day job + 3 demanding clients and their projects have me inundated.... and I'm trying to get EP4's update to github and the zencart team.

-chadd

chadderuski:

Hey guys,

There MAY be some small hope to do this. But, believe me, the attribute importing code is quite complex.

But, look at the DETAILED attribute export. This is a "special" file as it is one-to-one. When you export this file and look at the first columns, and examine the import code, you see that this is a very basic key lookup and replace loop.

That is why I made the creation of the values different than the updating.

I would be possible to modify the DETAILED attribute export code to also incorporate the SBA tables in a similar manner, and then do the same for the Import code.

Unfortunately, I don't have time right now. Day job + 3 demanding clients and their projects have me inundated.... and I'm trying to get EP4's update to github and the zencart team.

-chadd

Fully understood about having (or not having) the time. Part of the reason to try to document the process that might be needed and talk about what we have to work with. For me, the above direction may be enough to develop the code (same here time permitting), but just because I get my version to work doesn't mean that it would work for other versions of SBA, which to be honest I'm not 100% sure which version I installed. (2 years ago and I didn't take good notes like I should have about what specifically I installed and did to make it work, but it does or I have to make some manual tweaks once in a while.)

That said, thanks for the insight into where to look "next". Probably may end up as a mix of a couple of the routines, but would seem that in general a one-to-one would at least get the specific table updated. Would still need to pull from other tables to provide user friendly info, but seems even each of those is a one-to-one relationship.

Huh, actually, just took a look at the detailed attribute export file and for products that only have one attribute, this would be the way to go, would just have to add in the SQL to also capture the info in the SBA table so that it could be fed back. For mutliple attributes, though would have to probably build to the point of an SBA input just like when using the mod, ie, enter product, enter attributes that don't exist, assign attribute(s) to product, then populate the quantities of the product(s) that have the attribute(s). The only potential problem I see, is that the total quantity of an item would not be updated/synchronized by this process if the associated code isn't brought in/activated to perform a synchronization after import. In the interim though, I think that after population, the user could go into the admin panel and activate that operation.

Prior to this version of ZenCart, I used the "paid" version of Easy Pop which allowed assign the Product ID

Why no longer matters as I am accepting this is not posible in EP 4.

However, my Zen Cart currnently thinks I have the maximum number of product ID (214........)

I know this number cannot be changed.

And I have found that because of this, using the current Zen Cart and Easy Pop 4, I cannot add new product, etiher via EP4 or "manually"

I am concernter that if I just go into the SQL DB and reset the number, it will start using numbers already assigned to existing products and it will be an even bigger mess (if that is possible)

We do have other add on in use, but I know from past experience (and the error log) that they are not the problem.

Any suggestions.

Thank you for your consideration

Wheat

wheat:

Prior to this version of ZenCart, I used the "paid" version of Easy Pop which allowed assign the Product ID

Why no longer matters as I am accepting this is not posible in EP 4.

However, my Zen Cart currnently thinks I have the maximum number of product ID (214........)

I know this number cannot be changed.

And I have found that because of this, using the current Zen Cart and Easy Pop 4, I cannot add new product, etiher via EP4 or "manually"

I am concernter that if I just go into the SQL DB and reset the number, it will start using numbers already assigned to existing products and it will be an even bigger mess (if that is possible)

We do have other add on in use, but I know from past experience (and the error log) that they are not the problem.

Any suggestions.

Thank you for your consideration

Wheat
Essentially it sounds like you need to "clean" your database, which is a function available under the tools->Store Manager section of the admin panel.

Yes, your concern is valid about randomly assigning the product Id. As for using EP to assign the product_id, it is possible, but which is easier to "remember" when working on the data, item #2 or RosyRedFlowers? Also, as a programmer, basically by forcing the data table to accept this new product #52, can cause that table to obtain errors (something like, though not necessarily because of, the problems you are experiencing. ) It does take a little more planning by the store operator to make it work, but the resulting functionality is tremendous. And actually, EP might be able to fix your issue.

If you were to download all of the table data from your store, you could copy your store program code to another location, from there copy the existing database, wipe out the data within the applicable product tables, then upload (through EP) all of the product data again. If all data and associated referenc information is properly reset, the this would resolve your problem also, but seriously, back up back up, BACKUP and a number of other concerns to possibly do things this way. I still think the database compression/cleanup described above would be the best bet, if not at least a great start.

Thank you, I do understand what you are saying. However the issue is that ZenCart has a "hard coded" maximum number. For some reason buried back in about 2008 - my system "thought" it had reached that number.

The first line of the error report mention that number -

Fortunately I had a copy of the "other" EZ Pop and was able to find determine what the highest Prod ID really was. Once I knew that, the DB had to be manually edited (cannot be done thru any of the ZenCart Admin Pages) Equally. Fortunately once I realized what the problem - my other half was able to resolve the issue.

I had to delete one product and then change the product number to be incremented as products are added and it is all good until I do something else terminally stupid on purpose or accidentally.

Meanwhile because I am sometimes more adventurous than I should be, my SO wrote something so that the entire DB is backed up daily, zipped and sent via email so I always have a copy no older than 24 hours available.

Thank you for your thoughts, they make help with some other occasional issues.

Enjoy The Making

Wheat

Previous to EP4, I used the paid version. So sorry for all the "born a blonde, but white haired now" questions.

Is there something I can do to have the report include the master category number

Thank you for your time

Wheat

wheat:

Thank you, I do understand what you are saying. However the issue is that ZenCart has a "hard coded" maximum number. For some reason buried back in about 2008 - my system "thought" it had reached that number.

The first line of the error report mention that number -

Fortunately I had a copy of the "other" EZ Pop and was able to find determine what the highest Prod ID really was. Once I knew that, the DB had to be manually edited (cannot be done thru any of the ZenCart Admin Pages) Equally. Fortunately once I realized what the problem - my other half was able to resolve the issue.

I had to delete one product and then change the product number to be incremented as products are added and it is all good until I do something else terminally stupid on purpose or accidentally.

Meanwhile because I am sometimes more adventurous than I should be, my SO wrote something so that the entire DB is backed up daily, zipped and sent via email so I always have a copy no older than 24 hours available.

Thank you for your thoughts, they make help with some other occasional issues.

Enjoy The Making

Wheat

Okay, a couple of things, I can't imagine that the maximum number of products in your store can be 218 or whatever low number showed in this thread. After that, I find it difficult to have perhaps millions of products that are active in a single store.

As for the auto_number. As you said if you are able to find the "actual" next number, then you should go into your mySQLadmin panel and reset the auto_number to "that" number. Thing is, if not mistaken, the total number of items is limited by the server not so much Zen-Cart. If you are unable to use the standard Zen-Cart add product functionality, then this version of EP is most likely also not going to work.

wheat:

Previous to EP4, I used the paid version. So sorry for all the "born a blonde, but white haired now" questions.

Is there something I can do to have the report include the master category number

Thank you for your time

Wheat

Not sure what you mean by the master category number. You can export just about anything you want from the database. If I'm not mistaken though I thought the master category was named something else and included in the detailed download of the products. Once you have downloaded Chaddruski's version of EP, you could do whatever you want with it to export additional data if so desired, but at ones own risk.