Easy Populate 1.2.5.4 support

[valnoren]

Allright which version is the current one there's like 3 or 4 Easy Populates on the download area!
I use EP on an old cart and Im installing a new one and went to download and found several versions.???

http://www.zen-cart.com/index.php?ma...roducts_id=395

or

http://www.zen-cart.com/index.php?ma...oducts_id=1633

or

http://www.zen-cart.com/index.php?ma...oducts_id=1240

etc.

[MT85]

Allright which version is the current one there's like 3 or 4 Easy Populates on the download area!
I use EP on an old cart and Im installing a new one and went to download and found several versions.???

http://www.zen-cart.com/index.php?ma...roducts_id=395

or

http://www.zen-cart.com/index.php?ma...oducts_id=1633

or

http://www.zen-cart.com/index.php?ma...oducts_id=1240

etc.

I assume it would be this one, since it's listed as supporting 1.3.9 and the others are listed as supporting 1.3.8

http://www.zen-cart.com/index.php?ma...oducts_id=1633

[elkbow]

I just tested EP 1.2.5.4 on the following and no problems.

Version's
1.3.9
1.3.9a
1.3.9c
1.3.9d

[DamienDLSkinSolution]

Dear Zen Masters and Zen Padawans,

I was wondering if/how EasyPopulate could handle the data from Cross Sell... It would save a tremendous amount of time to so many of us if we could set the Cross Sell via Excel / EasyPopulate.

I figured how to add extra data in EasyPopulate, such as the Master Category ID...
I thought I had it for "xsell_id" and "sort_order", needed for the Cross Sell, but it ain't working...

I got about 0 php skills but here was my idea:

in admin/easypopulate.php i had:
Around line 384:

// langer - specials added below
        
            $header_array = array(
            'v_specials_price'    => $iii++,
            'v_specials_date_avail'     => $iii++,
            'v_specials_expires_date'     => $iii++,
            'v_products_price'    => $iii++,
            'v_products_price_w'    => $iii++,
            'v_products_weight'   => $iii++,
            'v_xsell_id'   => $iii++,
            'v_sort_order'   => $iii++,
            'v_master_categories_id'   => $iii++,
            'v_date_avail'      => $iii++,
            'v_date_added'      => $iii++,
            'v_products_quantity'   => $iii++,
            ); 

Around line 467:

$filelayout_sql = "SELECT
            p.products_id as v_products_id,
            p.products_model as v_products_model,
            p.products_image as v_products_image,
            p.products_price as v_products_price,
            p.products_price_w as v_products_price_w,
            p.products_weight as v_products_weight,
            xsell.xsell_id as v_xsell_id,
            xsell.sort_order as v_sort_order,
            p.master_categories_id as v_master_categories_id,
            p.products_date_available as v_date_avail,
            p.products_date_added as v_date_added,
            p.products_tax_class_id as v_tax_class_id,
            p.products_quantity as v_products_quantity,
            p.manufacturers_id as v_manufacturers_id,
            subc.categories_id as v_categories_id,
            p.products_status as v_status
            FROM
            ".TABLE_PRODUCTS." as p,
            ".TABLE_PRODUCTS_XSELL." as xsell,
            WHERE
            p.products_id = xsell.product_id
            ".TABLE_CATEGORIES." as subc,
            ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
            WHERE
            p.products_id = ptoc.products_id AND
            ptoc.categories_id = subc.categories_id
            "; 

Around line 1335:

// langer - why not qry products table and use result array??
    $default_these = array(
        'v_products_image',
        // redundant image mods removed
        'v_categories_id',
        'v_products_price',
        'v_products_price_w',
        'v_products_quantity',
        'v_products_weight',
        'v_xsell_id',
        'v_sort_order',
        'v_master_categories_id',
        'v_date_added',
        'v_date_avail',
        'v_instock',
        'v_tax_class_title',
        'v_manufacturers_name',
        'v_manufacturers_id',
        'v_products_dim_type',
        'v_products_length',
        'v_products_width',
        'v_products_height'
    ); 

Around line 1488:

// now do a query to get the record's current contents
        $sql = "SELECT
            p.products_id as v_products_id,
            p.products_model as v_products_model,
            p.products_image as v_products_image,
            p.products_price as v_products_price,
            p.products_price_w as v_products_price_w,
            p.products_weight as v_products_weight,
            xsell.xsell_id as v_xsell_id,
            xsell.sort_order as v_sort_order,
            p.master_categories_id as v_master_categories_id,
            p.products_date_added as v_date_added,
            p.products_date_available as v_date_avail,
            p.products_tax_class_id as v_tax_class_id,
            p.products_quantity as v_products_quantity,
            p.manufacturers_id as v_manufacturers_id,
            subc.categories_id as v_categories_id
            FROM
            ".TABLE_PRODUCTS." as p,
            ".TABLE_CATEGORIES." as subc,
            ".TABLE_PRODUCTS_XSELL." as xsell,
            WHERE
            p.products_id = xsell.product_id
            ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
            WHERE
            p.products_id = ptoc.products_id AND
            p.products_model = '" . zen_db_input($items[$filelayout['v_products_model']]) . "' AND
            ptoc.categories_id = subc.categories_id
            "; 

Around line 1984:

$query .="'".zen_db_input($v_products_model)."',
                                    '".zen_db_input($v_products_price)."',
                                    '".zen_db_input($v_products_price_w)."',
                                    '".zen_db_input($v_db_status)."',
                                    CURRENT_TIMESTAMP,
                                    $v_date_added,
                                    $v_date_avail,
                                    '".zen_db_input($v_tax_class_id)."',
                                    '".zen_db_input($v_products_weight)."',
                                    '".zen_db_input($v_xsell_id)."',
                                    '".zen_db_input($v_sort_order)."',
                                    '".zen_db_input($v_master_categories_id)."',
                                    '".zen_db_input($v_products_quantity)."',
                                    '$v_manufacturer_id')
                                "; 

and finally around line 2029:

$query .= '", products_weight="'.zen_db_input($v_products_weight) .
                        '", xsell_id="'.zen_db_input($v_xsell_id) .
                        '", sort_order="'.zen_db_input($v_sort_order) .
                        '", master_categories_id="'.zen_db_input($v_master_categories_id) .
                        '", products_tax_class_id="'.zen_db_input($v_tax_class_id) . 
                        '", products_date_available= ' . $v_date_avail .
                        ', products_date_added= ' . $v_date_added .
                        ', products_last_modified=CURRENT_TIMESTAMP' .
                        ', products_quantity="' . zen_db_input($v_products_quantity) .  
                        '" ,manufacturers_id=' . $v_manufacturer_id . 
                        ' , products_status=' . zen_db_input($v_db_status) . '
                        WHERE
                            (products_id = "'. $v_products_id . '")'; 

Obviously I'm off somewhere... (probably way off...)
Please php Gurus, don't laugh
Any help would be greatly appreciated.

Damien

[cecilsav]

Hello. Brand new to Zen cart and Easy Populate. I am running version 1.2.5.4 and Zen Cart v1.3.9b.

I had to pay to get EP installed but it I hope will be worth it. I have managed put together. I already had some products in my store and so I used a file pulled from the temp folder to add some new products to the store. I did so by clearing out all but 3 products and adding another 27. I saved it to my hardrive and inserted into the DB.
EP created the categories correctly but only downloaded 1 product.

Any reason for this? Thanks

Cecilsav

[Scrat]

cecilsav Firstly EP works with unique Model numbers (v_products_model) THEY MUST BE DIFFERENT so check that first...

A good test for EP is insert some sample products in via ZC and download change some detail and upload to ZC. EP just works fine if you are using v1.2.5.4. Watch out for the end of line ref EOREOR and also the v_status column
1 = Add
9 = Delete

What result did you get at the bottom of the EP window when you imported as this will give the information to what EP is doing with your data ?

Have you checked your permissions to the /temp folder as if you are not able to write to that folder EP will not change the data in that file in the folder.

[dropbop]

I have a few thousand products on my website which have no description but I need to add a description to each of them.

I have tried to upload an csv to EP with the headings v_products_model, v_products_description_1 but it didnt add the descriptions to the products on the site.

Any ideas? Or can it even be done this way?

Cheers

DB

[Scrat]

dropbop What version are you using as it looks as you are using EPA by the column ref.

EP should do this easily, have you remembered to use the end of line EOREOR ?

[KellyM]

Hello,

I'm curious as to whether or not anyone here has had success transferring products from MindBody to Zen Cart using Easy Populate. I've tried several times to import products from my MindBody store to my Zen Cart store to no avail, having followed all the instructions (literally nothing happens when I click "Insert into DB.")

I am wondering if I am doing something wrong or if it's just not possible to transfer this data, and it'd help to know how someone else exported their data from MindBody and imported it into Zen Cart.

Thanks for any help,

Kelly

[Scrat]

KellyM You would need to give us more details to help you...

EP works well, but has some strange querks. You need a product in a category placed in ZC manually for EP to import correctly, if you try to import without any products EP does not work properly.

If you arrange your .txt file as in the wiki EP will work, but it does need that format.