Page 318 of 359 FirstFirst ... 218268308316317318319320328 ... LastLast
Results 3,171 to 3,180 of 3588
  1. #3171
    Join Date
    May 2006
    Location
    Montana
    Posts
    291
    Plugin Contributions
    20

    Default Re: EasyPopulate 4.0 Support Thread

    Customer does not remember what version - and does not remember it saying V4 - just EZ Populate. It was an old 1.5.0 website.

    HOpe this helps

    HTML Code:
    status Arcos Manu Number Scan Number Name Jpeg File Cost Tubes Cost X3.5 Retail v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 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_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 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_1 v_metatags_keywords_1 v_metatags_description_1 1 ARC510-00030-01700 ARC510-00030-01700 790524056132 Silver Aluminum Matte ARC510-00030-01700.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01700 /p-czech/ARC510-00030-01700.jpg Silver Aluminum Matte ARC510-00030-01700 6.00 0 0 20 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01710 ARC510-00030-01710 790524056163 Light Gold Matte ARC510-00030-01710.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01710 /p-czech/ARC510-00030-01710.jpg Light Gold Matte ARC510-00030-01710 6.00 0 0 30 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01780 ARC510-00030-01780 790524056231 Copper Gold Matte ARC510-00030-01780.jpg 1.68 1 1.68 5.88 6.00
    Quote Originally Posted by mc12345678 View Post
    When you say EZP are you referring to one of the other versions? There is an issue if one doesn't format the categories using the caret (^) or other self selected divider when importing categories... recommend providing an example row of data, ensuring following the instructions and lastly identifying the version currently being used/tried...

  2. #3172
    Join Date
    Jul 2012
    Posts
    16,710
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by stellarweb View Post
    Customer does not remember what version - and does not remember it saying V4 - just EZ Populate. It was an old 1.5.0 website.

    HOpe this helps

    HTML Code:
    status Arcos Manu Number Scan Number Name Jpeg File Cost Tubes Cost X3.5 Retail v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 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_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 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_1 v_metatags_keywords_1 v_metatags_description_1 1 ARC510-00030-01700 ARC510-00030-01700 790524056132 Silver Aluminum Matte ARC510-00030-01700.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01700 /p-czech/ARC510-00030-01700.jpg Silver Aluminum Matte ARC510-00030-01700 6.00 0 0 20 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01710 ARC510-00030-01710 790524056163 Light Gold Matte ARC510-00030-01710.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01710 /p-czech/ARC510-00030-01710.jpg Light Gold Matte ARC510-00030-01710 6.00 0 0 30 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01780 ARC510-00030-01780 790524056231 Copper Gold Matte ARC510-00030-01780.jpg 1.68 1 1.68 5.88 6.00
    While the data doesn't come across well formatted, I see the indicators that I expected for it being an older/alternate EP...

    In EP4 as discussed in the instructions, the suffix '_1', '_2', '_3', etc. relates to the language that is being used... In one or more of the older versions, v_categories_name_1 was the "parent" category, v_categories_name_2 was the first sub-category off of the parent, v_categories_name_3 was the first sub-sub-category, etc...

    In EP4 a specific sub-category would be generated by concatenating each of those (that have content) with the carat '^'...

    So:
    Code:
    v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6
    shirt                 long-sleeve           no-buttons
    for EP4 would be combined in a single field (v_categories_name_1 or (when using the most recent version) v_categories_name_en) to:
    shirt^long-sleeve^no-buttons

    Where the language_id for the store is 1... While not fully implemented across all import file types, the language_code is now supported to instead use '_en' as the suffix for English instead of the language_id (_1).

    A way to accomplish that concatenation if the columns were say g, h, and i with the data starting in row2, then I would go to the next/last v_categories_name_X column, insert a new column, then use something like:

    Code:
    =IF(G2<>"",  G2, "") & IF(H2<>"", "^" & H2, "") & IF(I2<>"", "^" & I2, "")
    Now of course I wouldn't expect that there would be a "series" of information followed by an empty space then another with data (say _1 and _3 having data, but _2 not having data)...

    After I got the result, then I would copy that function down to the last row, then copy the contents in that column for all product and paste special that text into the appropriate column representing the language_id and delete the other v_categories_name_X columns including the one that was created to support this effort...

    Basically, EP4 supports multiple languages which older types did not appear to do so and the categories/sub-categories are identified as between each ^.

    This is also why it is important to not introduce spaces before/after each category. " shirt" is different than "shirt" and results in category creation/population to the "applicable" category....
    Last edited by mc12345678; 18 Sep 2020 at 06:57 PM.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3173
    Join Date
    Jan 2013
    Posts
    808
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    zen 1.56c with many modules
    easy populate downloads one field funny, as in the data base (products_barcode varchar(32))
    when i upload it back it uploads whats in the file.
    tried to upload file but exceed quota, but here is some of what is in the file
    v_products_barcode
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11

  4. #3174
    Join Date
    Jul 2012
    Posts
    16,710
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by jimmie View Post
    zen 1.56c with many modules
    easy populate downloads one field funny, as in the data base (products_barcode varchar(32))
    when i upload it back it uploads whats in the file.
    tried to upload file but exceed quota, but here is some of what is in the file
    v_products_barcode
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    At some point in modifying the exported data, it appears that the spreadsheet being used stopped considering the text provided as text and started treating it like a number... it then considered the number to need to be displayed in exponential numbers... therefore when the spreadsheet was saved to a csv file, the file then contained exponential numbers...

    This all happened outside of EP4 and specifically in the spreadsheet being used... you'll likely have to go back a few exports to find the original values that were brought into your spreadsheet program. In the future treat this field as a text field and don't let your spreadsheet program convert it to a number...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #3175
    Join Date
    Jan 2013
    Posts
    808
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    my steps were, open ep, choose manufacturer, than export, than download to computer, than open in excel. than i copied some rows pasted them here.

  6. #3176
    Join Date
    Jul 2012
    Posts
    16,710
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by jimmie View Post
    my steps were, open ep, choose manufacturer, than export, than download to computer, than open in excel. than i copied some rows pasted them here.
    "Looking" at them in excel is why the numbers are converted to the scientific notation that was posted... Again, this is not something that was done in EP4. EP4 generates the CSV file that was downloaded. If it is looked at with your favorite plain text editor just after download and before ever being edited with Excel or Open Office then will see the number(s) in their entirety and not shortened.

    There are plenty of ways to request that numbers be treated as text when either importing a file or reviewing the content.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  7. #3177
    Join Date
    Jul 2005
    Location
    Orlando, Fl
    Posts
    324
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    v_products_barcode
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    7.34995E+11
    Jimme,

    I had the same issue with UPC codes, it's a pain.

    Here is how I solved it.

    I added UPC before every code in the database, so instead of this -> 697666007421 in the db it was this -> UPC697666007421

    Then i used php to remove the UPC when it's displayed on the front end.

    PHP Code:
    str_replace("UPC","",$upc['products_upc']) 
    It's a workaround but solves that issue.

  8. #3178
    Join Date
    Jan 2004
    Posts
    66,363
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: EasyPopulate 4.0 Support Thread

    In Excel, to "format number fields as text instead of scientific notation", select the entire column, press CTRL+1 (or CMD+1) and change the format to Text

    https://www.excelhow.net/convert-sci...-in-excel.html
    https://www.extendoffice.com/documen...n-to-text.html
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  9. #3179
    Join Date
    Mar 2016
    Location
    Marietta GA
    Posts
    70
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Hello, I'd like to make sure that this plugin fits my use case before proceeding.

    We have existing categories on our ZC 1.5.5e site, to which we need to add 125 or more products. Do I understand that with this plugin, I can put the 125 products into an appropriately formated / column header CSV, and mass import my products in one operation? Thus avoiding the tedious GUI of creating 125 products. Thanks for clarifying.

  10. #3180
    Join Date
    Jul 2012
    Posts
    16,710
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by greg_beyer View Post
    Hello, I'd like to make sure that this plugin fits my use case before proceeding.

    We have existing categories on our ZC 1.5.5e site, to which we need to add 125 or more products. Do I understand that with this plugin, I can put the 125 products into an appropriately formated / column header CSV, and mass import my products in one operation? Thus avoiding the tedious GUI of creating 125 products. Thanks for clarifying.
    Absolutely correct. Suggest exporting product from that category (if at least one is already present) to make a good example of how it should look when preparing the new upload. (remember that the csv file has a different appearance than that content loaded into a spreadsheet.)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. BackUp ZC [Support Thread]
    By skipwater in forum All Other Contributions/Addons
    Replies: 285
    Last Post: 23 Dec 2020, 10:40 AM
  3. Wordpress On ZC [Support Thread]
    By hira in forum All Other Contributions/Addons
    Replies: 1858
    Last Post: 17 Jan 2014, 01:24 AM
  4. ZJ Black 2 support thread
    By Liamv in forum Addon Templates
    Replies: 1
    Last Post: 15 Feb 2010, 02:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR