EasyPopulate 4.0 Support Thread

[Feznizzle]

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

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!

[fabienne]

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.

[fabienne]

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.

[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.

[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.

[chadderuski]

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

[chadderuski]

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

[mc12345678]

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.

[propster]

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

[mc12345678]

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.