Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

try loading one product, also make sure that it is assigned to a category and you have a model #.

what do you have for your DOCUMENT_ROOT setting in your admin/includes/configure.php file.

what is your ep file setting at, tab or semicolon?

Link to comment
Share on other sites

Is there a any version of EP that can delete products ?

 

For ex. if i delete a product in the tab delimited file, when i up-load it, the produsct remians in database .

 

 

I search in easypopulate.php , i i found something like :

 

//**** Status Field Setting ****

// Set the v_status field to "Inactive" if you want the status=0 in the system

// Set the v_status field to "Delete" if you want to remove the item from the system <- THIS IS NOT WORKING YET!

// If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store.

global $active, $inactive, $zero_qty_inactive, $deleteit;

$active = 'Active';

$inactive = 'Inactive';

//$deleteit = 'Delete'; // not functional yet

$zero_qty_inactive = true;

 

/////

 

thanks .

Link to comment
Share on other sites

Has anyone gotten easy populate to work with Additional Images V 1-13? I am trying to follow the directions in the pdf that say to search for bimage and folow the instructions to delete the comments in the code. I didn't see any instructions in the code about deleting the comments, so I just deleted the comments that were near the bimage lines

 

 

/*

$query .= . $v_products_mimage . '", "'

. $v_products_bimage . '", "'

. $v_products_subimage1 . '", "'

. $v_products_bsubimage1 . '", "'

. $v_products_subimage2 . '", "'

. $v_products_bsubimage2 . '", "'

. $v_products_subimage3 . '", "'

. $v_products_bsubimage3 . '", "'

*/

 

and here

 

 

/*

$query .=

'" ,products_mimage="'.$v_products_mimage.

'" ,products_bimage="'.$v_products_bimage.

'" ,products_subimage1="'.$v_products_subimage1.

'" ,products_bsubimage1="'.$v_products_bsubimage1.

'" ,products_subimage2="'.$v_products_subimage2.

'" ,products_bsubimage2="'.$v_products_bsubimage2.

'" ,products_subimage3="'.$v_products_subimage3.

'" ,products_bsubimage3="'.$v_products_bsubimage3;

*/

 

 

I received the error

[client 68.193.228.144] PHP Parse error: parse error, unexpected '.' in /var/www/html/admin/easypopulate.php on line 1716

 

 

That relates to the top line of the first piece of code I posted above? Does anyone have any ideas?

 

Thanks in advance!!!

Link to comment
Share on other sites

Hi all,

 

Does anyone have an idea about SPPC + Price Breaks for SPPC get together into EP?

I have been arround here for 2 days but found no answer yet.

 

I know about the uncommenting parts for SPPC and have edited EP so far, but the pricebreaks don't come up in the downloadfile.

 

Option: Download Model/Price/Qty tab-delimited .txt file to edit

shows the pricebreaks for retail but for the other customergroups I just get the main prices, not the pricebreaks.

 

And I dont get the qty's for the pricebreaks in this one, but that works in the normal "full" download fine...

 

v_products_model        v_products_price        v_products_price1        v_products_price2        v_products_price3        v_products_price4        v_products_price5        v_products_price6        v_products_price7        v_products_price8        v_products_price1_qty        v_products_price2_qty        v_products_price3_qty        v_products_price4_qty        v_products_price5_qty        v_products_price6_qty        v_products_price7_qty        v_products_price8_qty        v_products_qty_blocks        v_products_quantity        v_customer_price_1        v_customer_group_id_1        v_customer_price_2        v_customer_group_id_2        v_customer_price_3        v_customer_group_id_3        v_customer_price_4        v_customer_group_id_4        EOREOR

bird01        43.1        0        0        0        0        0        0        0        0                                                                                -107        34.4828        1        25.8621        2                                        EOREOR

 

Thanks for any hints!!!

G?tz

Link to comment
Share on other sites

you need to look at the sample txt file in the docs to see what ep creates, also download from your own site to verify all is there. then you can starting adding fields ( i would do one or two at a time ) and once you have the right spot in ep you can add the rest of the fields necessary.

Link to comment
Share on other sites

Hi everybody... I hope this is the right place to post my question, here goes:

 

I've just installed Easy Populate and it seems to be working just fine with one exception (and it's probably my fault). I have a category called 15" - 28", and whenever I upload my database file into EP, it always creates a new category called 5" - 28. And it duplicates the products that are in the 15" - 28" category.

 

I've deduced that my problem is my use of " in my category names... is there any way to get around this? I tried replacing all of the " with \" but that just causes errors. I'm extremely new to all of this so forgive me if the answer is common knowledge. :-)

 

Thanks in advance.

Link to comment
Share on other sites

ep is only populating the database with the filename for the image, it does not upload the image. thus you need to ftp all your images and you need to have exact names.

Link to comment
Share on other sites

Hi, some of my items have attributes selectable by a pull down box, these show up fine in the cart.

eg colour - blue

 

Others have attributes where the user enters text, I have added easypopulate.

 

In the cart these show the text entered but not the attribute name before the dash.

 

This is a problem because there are 7 textboxes and if a user only inputs into some of them I dont know which.

 

I have looked in the database, there is an entry in the attribute_nane fiele and I have had a look in shopping_cart.php but I cannot fathom this.

 

Any help appreciated,

 

Rick.

 

If the above isnt clear click below, punch some numbers in then go to the cart.

http://www.justrimless.com/catalog/product...products_id=179

Link to comment
Share on other sites

I have a ramdom question.

 

Is there any way to handle specials through ezPopulate?

 

If not has anyone seen a contrib. that makes specials eaiser to apply.

 

I run alot of specials through my site.

 

Thanks in advance

Link to comment
Share on other sites

Installed Easy Populate and it's panel comes up fine. But if I click ANY of the options no files are created or read and NO error msgs created.

 

I can hit "Insert into db" with NO file selected or defined and again, No error is returned.

 

I can select ANY file on my computer to upload and no error is returned.

 

(osCommerce is working fine)

 

Can anyone help?

Link to comment
Share on other sites

you need to look at the sample txt file in the docs to see what ep creates, also download from your own site to verify all is there.  then you can starting adding fields ( i would do one or two at a time ) and once you have the right spot in ep you can add the rest of the fields necessary.

Fantastic answer!

Yep, the docs say nothing, but:

 

SUPPORT FOR SPPC 4.1 WITH Quantity Price Breaks for Separate Pricing Per Customer

 

        case 'priceqty':
               $iii = 0;
               // uncomment the customer_price and customer_group to support multi-price per product contrib
               $filelayout = array(
                       'v_products_model'                => $iii++,
                       'v_products_price'                => $iii++,
                       'v_products_quantity'                => $iii++,
                       'v_status'                => $iii++,
                       'v_products_qty_blocks' => $iii++,
                       'v_products_price1' => $iii++,
                       'v_products_price1_qty' => $iii++,
                       'v_products_price2' => $iii++,
                       'v_products_price2_qty' => $iii++,
                       'v_products_price3' => $iii++,
                       'v_products_price3_qty' => $iii++,
                       'v_products_price4' => $iii++,
                       'v_products_price4_qty' => $iii++,
                       'v_products_price5' => $iii++,
                       'v_products_price5_qty' => $iii++,
                       'v_products_price6' => $iii++,
                       'v_products_price6_qty' => $iii++,
                       'v_products_price7' => $iii++,
                       'v_products_price7_qty' => $iii++,
                       'v_products_price8' => $iii++,
                       'v_products_price8_qty' => $iii++,
                       'v_customer_price_1'                => $iii++,
                       'v_customer_group_id_1'                => $iii++,
                       'v_products_qty_blocks_1' => $iii++,
                       'v_products_price1_1' => $iii++,
                       'v_products_price1_qty_1' => $iii++,
                       'v_products_price2_1' => $iii++,
                       'v_products_price2_qty_1' => $iii++,
                       'v_products_price3_1' => $iii++,
                       'v_products_price3_qty_1' => $iii++,
                       'v_products_price4_1' => $iii++,
                       'v_products_price4_qty_1' => $iii++,
                       'v_products_price5_1' => $iii++,
                       'v_products_price5_qty_1' => $iii++,
                       'v_products_price6_1' => $iii++,
                       'v_products_price6_qty_1' => $iii++,
                       'v_products_price7_1' => $iii++,
                       'v_products_price7_qty_1' => $iii++,
                       'v_products_price8_1' => $iii++,
                       'v_products_price8_qty_1' => $iii++,
                       'v_customer_price_2'                => $iii++,
                       'v_customer_group_id_2'                => $iii++,
                       'v_customer_price_3'                => $iii++,
                       'v_customer_group_id_3'                => $iii++,
                       'v_customer_price_4'                => $iii++,
                       'v_customer_group_id_4'                => $iii++,
                               );
               $filelayout_sql = "SELECT
                       p.products_id as v_products_id,
                       p.products_model as v_products_model,
                       p.products_status as v_status,
                       p.products_price as v_products_price,
                       p.products_tax_class_id as v_tax_class_id,
                       p.products_price1 as v_products_price1,
                       p.products_price2 as v_products_price2,
                       p.products_price3 as v_products_price3,
                       p.products_price4 as v_products_price4,
                       p.products_price5 as v_products_price5,
                       p.products_price6 as v_products_price6,
                       p.products_price7 as v_products_price7,
                       p.products_price8 as v_products_price8,
                       p.products_price1_qty as v_products_price1_qty,
                       p.products_price2_qty as v_products_price2_qty,
                       p.products_price3_qty as v_products_price3_qty,
                       p.products_price4_qty as v_products_price4_qty,
                       p.products_price5_qty as v_products_price5_qty,
                       p.products_price6_qty as v_products_price6_qty,
                       p.products_price7_qty as v_products_price7_qty,
                       p.products_price8_qty as v_products_price8_qty,
                       p.products_qty_blocks as v_products_qty_blocks,
                       p.products_quantity as v_products_quantity
                       FROM
                       ".TABLE_PRODUCTS." as p
                       ";

               break;

// If you got more customergroups, add the fields to the 
// $filelayout array only.

 

and

 

                        if ($v_customer_price_1 != ''){
                               $result = tep_db_query('
                                                       INSERT INTO
                                                               '.TABLE_PRODUCTS_GROUPS.'
                                                       VALUES
                                                       (
                                                               ' . $v_customer_group_id_1 . ',
                                                               ' . $v_customer_price_1 . ',
                                                               ' . $v_products_id . ',
                                                               ' . $v_products_price1_1 . ',
                                                               ' . $v_products_price2_1 . ',
                                                               ' . $v_products_price3_1 . ',
                                                               ' . $v_products_price4_1 . ',
                                                               ' . $v_products_price5_1 . ',
                                                               ' . $v_products_price6_1 . ',
                                                               ' . $v_products_price1_qty_1 . ',
                                                               ' . $v_products_price2_qty_1 . ',
                                                               ' . $v_products_price3_qty_1 . ',
                                                               ' . $v_products_price4_qty_1 . ',
                                                               ' . $v_products_price5_qty_1 . ',
                                                               ' . $v_products_price6_qty_1 . ',
                                                               ' . $v_products_qty_blocks_1 . ',
                                                               ' . $v_products_price7_1 . ',
                                                               ' . $v_products_price8_1 . ',
                                                               ' . $v_products_price7_qty_1 . ',
                                                               ' . $v_products_price8_qty_1 . '
                                                               )'
                                                       );
                       }

// Note: the fields must be in the right order as your database
// is organized, I added 2 prices later, so my DBstructure differs...
// If you have more than 1 extra Customergroup, 
// you have to edit the next section below for $v_customer_price_2 and 
// change all last 1s into 2s

 

 

And here we go!

G?tz

Link to comment
Share on other sites

I take it you were able to follow things and it is working properly?

 

by the way, the docs is for the 'adding new fields to easy populate' contribution.

Edited by Mibble
Link to comment
Share on other sites

follow the instructions within the ep docs, also set the DOCUMENT_ROOT setting to $DOCUMENT_ROOT in the admin/includes/configure.php file, then set your temp file settings in the ep file to match

Link to comment
Share on other sites

EasyPopulate 2.2-MS2

 

as info: I'm new to php... I have some perl cgi experience.

 

I installed EP and EP panel comes up fine. (So script without 'options" on url works fine.)

 

When ANY selection is made (upload, download, etec) the script runs just as it does with no options on url. In other words, the panel is displayed and that's it. There are no error msgs.

 

I have deduced that the "options" (appened to the url) are not being passed to the script. For example:

 

Clik on download file and the script runs with "/easypopulate.php?download=stream&dltype=full" added to the url.

 

But if I echo $download and $dltype they are null.

 

I went into script and immediately before the "Download File" section I manually set $download=stream and $dltype=full.

 

When I run the script with the "options" hardcoded it does try to do a download but I get a 1065 - Query was empty - error on this line: $result = tep_db_query($filelayout_sql);

 

Yes, I do have a few items in my cart...

 

 

1.) what would cause the ?options on the url not to pass to script?

2.) why would cause the Query empty error on $result = tep_db_query($filelayout_sql);

 

Help????

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...