The statement was made based on using the German provided version of Zen Cart. In the German provided Zen Cart the version check option is disabled/removed.
With the removal of the version check software in the German Zen Cart, older versions oF EasyPopulate V4 would generate errors because it does try to check the US/Canada Zen Cart site for newer versions.
I know I wanted to make EP4 easier for use when installed. I need to look to see if I did anything to make it easier. Otherwise, I know I have seen some discussion in the following forum group about how to use this version of EP4 with the ZC provided by webchills: https://www.zen-cart-pro.at/forum/fo...-Easy-Populate
So, question is does it work now or are there still problems?
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
The store admin accidentally deleted a complete product category and asked me to fix this. The latest database backup available is three weeks old, so instead of restoring the complete database, I figured I could use EasyPopulate to
1) Export the category after restoring the backup. I intend to do this on a local copy of the website (xampp) that I currently have runnin because of a recent upgrade after years of not working with Zen Cart.
2) Import the export file into the live site.
I never worked with EP before so I tested it first on the locally running site by
1) Creating an export of a product category. This seems to work.
2) Deleting said product category. This obviously works.
3) Importing the export. This does not work. The bar at the top displays "File Import Completed," but the import report at the bottom says
To make things simpler, I created a new category of 1 level with only one product. I exported this category, then deleted the product (but kept the category), then tried to import with the same result. The export file looks like this:Code:Import Results Filename: Full-EP2021-02-14-093948.csv Finished Processing Import File Updated records: 0 New Imported records: 0 Errors Detected: 0 Warnings Detected: 0 Memory Usage: 5638888 Memory Peak: 6571048 Execution Time: 0 seconds.
I use ZC version 1.5.7b and the latest EP from the github link from the plugins page.Code:v_products_model,v_products_type,v_products_image,v_products_name_2,v_products_description_2,v_products_url_2,v_products_name_8,v_products_description_8,v_products_url_8,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_product_is_call,v_products_sort_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products_priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_2,v_categories_name_8,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_2,v_metatags_keywords_2,v_metatags_description_2,v_metatags_title_8,v_metatags_keywords_8,v_metatags_description_8 "","1","","test","beschrijving","","test","description","","","","","9.92","0","0","0","1","1","0","0","","2021-02-14 09:39:04","0","Anemoontje","pakketjes","pakketjes","19","1","0","0","0","0","0","","","","","",""
Thanks in advance for any help!
So first thing is that the product (at least as shown in this one record) does not have a products_model assigned to it. Not a requirement in all situations, but in a default install, products_model is the primary key. Blank means don't do anything with it. Appears would be good to have notification of that situation/issue.
So... what can be done to at least restore the product? Go back to the original state of the database and as far as EP4 is concerned, adjust the configuration settings to use the primary key of products_id. Then export the product within that category to use that data for recreation of the product to have the exact same products_id that it previously had. *NOTE* this is one place where care and understanding about the condition and status of the destination database must be taken and known. You don't want to *also* mess up a product that already exists.
Now, as to the true "recreation" of the category (which appears to be the original intent), will also need to export category files in addition to the product files provided above.
The process followed so far is expected to simply create the place holder for the category. But the category will have nothing really in it. No category description for example. Further, because there are at least two languages involved, will want to be sure that the appropriate information is carried in each of the languages within the category...
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Thank you for your quick reply! Setting the primary key to product_id makes everything work as expected. I will have to check whether problems arise with existing product_ids. Not sure whether ID's are recycled, but if not there should not be a problem because the source DB is a backup of the destination DB. I will continue on this tomorrow.
Thank you for the tip about recreation of the categories too. I didn't figure that would be necessary.
v1.5.7b PHP7.3 Easy Populate 4.0.36.ZC (mc12345678 version)
I have 1 issue below, as well as one question below.
I am receiving similar myDEBUG errors as the one indicated on previous page relating to line 661 - thrown when generating a Full EP request - the file is produced no problem at all so it appears it is not detrimental to function - my error however refers to a number of instances and different line numbers as per example below (truncated the error log - it continues further alternately with errors in line 655 and 651 - so is the fix the same for the different lines as it is for 661?;
QUESTIONCode:[16-Feb-2021 17:00:09 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:281] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 281. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1 - assumed 'ORDERSEXPORT_LINK_SAVE1' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 605. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1B - assumed 'ORDERSEXPORT_LINK_SAVE1B' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 606. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE2 - assumed 'ORDERSEXPORT_LINK_SAVE2' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 607. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE3 - assumed 'ORDERSEXPORT_LINK_SAVE3' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 608. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:655] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:661] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:655] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:661] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:655] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655. [16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235 #1 sizeof() called at [/dazzlers/easypopulate_4.php:661] #2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11] --> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661.
Can this plugin produce the complete url for images rather than the shortened version (e.g. earrings/clip-on-earrings-527.jpg is produced but needs to be https://www.dazzlerscliponearrings.com.au/images/earrings/clip-on-earrings-527.jpg) this is required so I can create a Google Merchant Center feed - if it can, then how can I make any mods to get this result?
cheers,
Mike
Please see the first sentence of the above first post, then please follow the link in the second post (yes, written in what I would say is broken German as I seriously doubt it had all of the correct grammar and words).
As to the full path to images, the question would be does it need to be autogenerated to have that or could it be generated after download as part of providing the file to the associated service?
Currently, there is not a full auto-generation step in the code, but it could be incorporated. Recommendation would be to produce an additional field in the file so that the data of the original field could still be properly used.
Ohh, and lastly, would recommend changing the folder name for your admin and as necessary/appropriate may need to do the same in your store's .htaccess if you have generated one and it contains the current admin folder name in it.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...