Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

without going into too much technical detail can anyone point me in the direction that I need to go in? Is there some code in a PHP file somewere that may be wrong ? ? ?

Please Help :thumbsup:

View recent 'helpfull' threads:

 

403 Error problems | Ultimate SEO (contribution support)

Link to comment
Share on other sites

without going into too much technical detail can anyone point me in the direction that I need to go in? Is there some code in a PHP file somewere that may be wrong ? ? ?

Please Help :thumbsup:

 

open

 

admin/easypopulate.php

 

line 154:

 

//**** Size of products_model in products table ****
// set this to the size of your model number field in the db.  We check to make 
// sure all models are no longer than this value. this prevents the database from 
// getting fubared.  Just making this number bigger won't help your database!  They must match!
// If you increase the Model Number size, you must increase the size of the field
// in the database. Use a SQL tool like phpMyAdmin (see your host) and change the
// "products_model" field of the "products" table in your osCommerce Database.
define ('EP_MODEL_NUMBER_SIZE', 12); // default is 12

 

change to 30

Link to comment
Share on other sites

I've got Easy Populate 2.76d-MS2 installed, and can download the txt file to edit.

 

I get a few error messages when I try to Upload and Import EP File.

Your help would be greatly appreciated. Thanks.

 

Warning: move_uploaded_file(DIR_FS_DOCUMENT_ROOT/var/www/html/shop/temp/EP2007Sep28-1503.txt): failed to open stream: No such file or directory in /var/www/html/shop/admin/easypopulate_functions.php on line 43

 

Warning: move_uploaded_file(): Unable to move '/tmp/phpLJRGWw' to 'DIR_FS_DOCUMENT_ROOT/var/www/html/shop/temp/EP2007Sep28-1503.txt' in /var/www/html/shop/admin/easypopulate_functions.php on line 43

 

File uploaded.

Temporary filename: /tmp/phpLJRGWw

User filename: EP2007Sep28-1503.txt

Size: 56496

 

Warning: file(DIR_FS_DOCUMENT_ROOT/var/www/html/shop/temp/EP2007Sep28-1503.txt): failed to open stream: No such file or directory in /var/www/html/shop/admin/easypopulate.php on line 805

 

Warning: Invalid argument supplied for foreach() in /var/www/html/shop/admin/easypopulate.php on line 844

Link to comment
Share on other sites

Hello,

 

I'd been working on getting easypopulate to handle product attribs, and managed to achieve something functional. I haven't tested the code extensively yet, but it should theoretically be capable of handling any number of product options, option values, and languages.

 

This is still beta code, and I haven't put it up as a contribution yet. If anyone is interested in giving this a try (at their own risk!), you can download my easypopulate.php file, and a sample tab-limited file (from an 'out-of-the-box' osc product list), here.

 

Please try this on a test osc setup, before you even think about using it in your "live" store. And in any case, BACKUP your database.

 

This code was developed and tested with EP version '2.62-MS2' on oscommerce 2.2-MS2.

 

Here's an overview of the system. Hope its not confusing as it looks, and makes some sense :).

FIELD STRUCTURE

-----------------------

 

1. v_attribute_options_id_1
� � � �v_attribute_options_name_1_1
� � � �v_attribute_options_name_1_2
� � � �.
� � � �.
� � � �.
� � � �v_attribute_values_id_1_1
� � � �v_attribute_values_price_1_1
� � � � � �v_attribute_values_name_1_1_1
� � � � � �v_attribute_values_name_1_1_2
� � � � � �.
� � � � � �.
� � � � � �.
� � � �v_attribute_values_id_1_2
� � � �v_attribute_values_price_1_2
� � � � � �v_attribute_values_name_1_2_1
� � � � � �v_attribute_values_name_1_2_2
� � � � � �.
� � � � � �.
� � � � � �.
� � � �.
� � � �.
� � � �.

2. v_attribute_options_id_2
� � � �v_attribute_options_name_2_1
� � � �v_attribute_options_name_2_2
� � � �.
� � � �.
� � � �.
� � � �v_attribute_values_id_2_1
� � � �v_attribute_values_price_2_1
� � � � � �v_attribute_values_name_2_1_1
� � � � � �v_attribute_values_name_2_1_2
� � � � � �.
� � � � � �.
� � � � � �.
� � � �v_attribute_values_id_2_2
� � � �v_attribute_values_price_2_2
� � � � � �v_attribute_values_name_2_2_1
� � � � � �v_attribute_values_name_2_2_2
� � � � � �.
� � � � � �.
� � � � � �.
� � � �.
� � � �.
� � � �.
.
.
. � �	

where, 

1. v_attribute_options_id_x

�x = a count, beginning from 1, and incrementing by 1

This column contains the options ID (each option ID must be unique).
2. v_attribute_options_name_x_y

�x = count (same as above)
�y = count and language id . This means, language id must correspond to the count, begin on 1, and increment by 1. 

For example, 

correct language id structures include, 

�English (ID = 1), German (ID = 2) and Spanish (ID = 3)
�English (ID = 1) and French (ID = 2)

and the system most likely won't work with the following language id structures, 

�English (ID = 2) and German (ID = 3)
�French (ID = 2)
So basically, if you're using 3 languages (say, English, German and French) make sure their language ids begin with 1, and increment by 1, without jumping values. 

This column contains the option name (in each language).


3. v_attribute_values_id_x_y

�x = corresponding option count
�y = option values count, beginning from 1, and incrementing by 1

This column contains the option value ID (each option value ID must be unique).
4. v_attribute_values_price_x_y

�x = corresponding option count
�y = option values count

This column contains the "signed" price. If non-empty, attribute value is added to the product. 
5. v_attribute_values_name_x_y_z

�x = corresponding option count
�y = corresponding option values count
�z = count and language id . This means, language id must correspond to the count, begin on 1, and increment by 1 (please see description for v_attribute_options_name_x_y).

HOW IT WORKS

--------------------

 

Basically, if the field "v_attribute_values_price_x_y" is not empty for a product row, the corresponding attribute is added to that product. Example non-empty values include,

 

0 (zero) = just the attribute is added (there's no special price)

11.50 = attribute is added, with price value 11.50, and price prefix '+'

-9.30 = attribute is added, with price value 9.30, and price prefix '-'

 

You'll also be able to add product options/option values, modify option/option value names.

VJ

 

 

 

 

Hello I have installed the latest version of Easy Populate into my store. I already had EZ New Fields installed and I want to find out how I can integrate the retail price field into Easy Populate. I've downloaded Dave Case's instructions (here) on how I can integrate them, however, the code that dave refers to is not in the version of EP that I have. Can someone show me how to do this? Below is the pertinent data:

 

1) PHP Version:

4.4.7 (Zend: 1.3.0)

 

Server Type & version

Linux 2.6.16.33-20070131a-areca-filemon-3ware-e1000

 

2) Set EP_SHOW_EP_SETTINGS to true in the EP settings and then

copy the settings that are displayed on the EP main page into your post.

 

Settings

 

EP vers: 2.76e

Temp Dir:

/homepages/21/d202393536/htdocs/wii/Backup/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: true

SPPC: false

Extra Fields: true

 

 

3) Copy of any error message you are receiving.

No error messages, just not seeing the retail price field

 

4) Post a link to a sample of any upload file you are trying. I don't have a sample file

 

5) Place all information in your post. Done.

 

I am running a moderately modified OSC 2.2 rc1

 

Any help would be greatly appreciated.

 

Lionel

Link to comment
Share on other sites

Sorry, forgot to include the code that is tripping me up. In David's instructions, he wants me to Find the line, approx 991: $filelayout = array_merge($filelayout , array(

'v_tax_class_title' => $iii++,

'v_status' => $iii++,

 

This line does not exsist in my /admin/easypopulate.php file

Link to comment
Share on other sites

Sorry, forgot to include the code that is tripping me up. In David's instructions, he wants me to Find the line, approx 991: $filelayout = array_merge($filelayout , array(

'v_tax_class_title' => $iii++,

'v_status' => $iii++,

 

This line does not exsist in my /admin/easypopulate.php file

 

 

OK, I figured it out. I added "v_products_retail_price to almost every location where v_product_price was. It seems to work with the items I already have in my store. However, now I have a different problem now. I tried to upload a file with new items in it and I get the following error in easypopulate.php:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and scenes. Ultimate Battle Z mode uses the ladder type tournam

UPDATE products SET products_price=' you can unlock new characters', products_image=' the story can and will change to match the outcome of your fighters. If you can collect enough wins in a given portion of the story', products_weight=' players fight one match after another as they climb the ladder of increasingly difficult foes. Each selectable ladder of bouts has a different condition or theme. Once a player completes a ladder', products_tax_class_id='', products_date_available='1969-12-31 18:59:59', products_date_added='2007-10-02 18:36:17', products_last_modified='2007-10-02 18:36:17', products_quantity = and scenes. Ultimate Battle Z mode uses the ladder type tournament system of fighting made popular by the fighting game Mortal Kombat. In this system, products_retail_price=' powers', manufacturers_id = 13, products_status = 1 WHERE (products_id = 50) LIMIT 1

 

I also get a new category on the catalog side called 32.99 . Does anyone have any ideas?

Link to comment
Share on other sites

OK, I figured it out. I added "v_products_retail_price to almost every location where v_product_price was. It seems to work with the items I already have in my store. However, now I have a different problem now. I tried to upload a file with new items in it and I get the following error in easypopulate.php:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and scenes. Ultimate Battle Z mode uses the ladder type tournam

 

I also get a new category on the catalog side called 32.99 . Does anyone have any ideas?

 

your fields names and data don't match: your product price looks like a description. you probably have to go back to the drawing board when you add a new field. You must have missed an occurence of products_price somewhere (be careful with the $products_price and products_price - without the dollar sign) if you work with a search and replace tool)

Edited by pixclinic
Link to comment
Share on other sites

 

File uploaded.

Temporary filename: /tmp/phpHuHOf1

User filename: EP2007Oct03-0707.csv

Size: 133181

1054 - Unknown column 'p.product_retail_price' in 'field list'

 

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_weight as v_products_weight,
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.product_retail_price as v_product_retail_price,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status_current
FROM products as p, categories as subc, products_to_categories as ptoc
WHERE p.products_model = 'wiiclassic'
AND p.products_id = ptoc.products_id 
AND ptoc.categories_id = subc.categories_id
LIMIT 1

[TEP STOP]

I have a feeling that I either missed a spot in adding the products_retail_price or I added it in the wrong spot. I just don't know where or even if that is it. Can anyone decern what the missing link is here?

 

Thanks

Lionel

 

the error reads that product_retail_price doesn't exist....

in the aditions you made, you referred as products_retail_price,

WITH AN S AT PRODUCTS. And you query doesn't have an S at p.product_retail_price

 

PS: if you could put line breaks in your queries when you post some code, that would make the threat much easier to read :-)

Edited by pixclinic
Link to comment
Share on other sites

File uploaded.

Temporary filename: /tmp/phpHuHOf1

User filename: EP2007Oct03-0707.csv

Size: 133181

1054 - Unknown column 'p.product_retail_price' in 'field list'

 

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_weight as v_products_weight,
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.product_retail_price as v_product_retail_price,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id,
p.products_status as v_status_current
FROM products as p, categories as subc, products_to_categories as ptoc
WHERE p.products_model = 'wiiclassic'
AND p.products_id = ptoc.products_id 
AND ptoc.categories_id = subc.categories_id
LIMIT 1

[TEP STOP]

I have a feeling that I either missed a spot in adding the products_retail_price or I added it in the wrong spot. I just don't know where or even if that is it. Can anyone decern what the missing link is here?

 

Thanks

Lionel

the error reads that product_retail_price doesn't exist....

in the aditions you made, you referred as products_retail_price,

WITH AN S AT PRODUCTS. And you query doesn't have an S at p.product_retail_price

 

PS: if you could put line breaks in your queries when you post some code, that would make the threat much easier to read :-)

 

Hey,

 

Thanks for your input, I can't believe I made that bonehead mistake! :blush: I've since fixed that but I got another error after I tried to upload a file:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and scenes. Ultimate Battle Z mode uses the ladder type tournam

 

UPDATE products SET products_price=' you can unlock new characters', products_image=' the story can and

will change to match the outcome of your fighters. If you can collect enough wins in a given portion of the

story', products_weight=' players fight one match after another as they climb the ladder of increasingly difficult

foes. Each selectable ladder of bouts has a different condition or theme. Once a player completes a ladder', products_tax_class_id='', products_date_available='1969-12-31 18:59:59', products_date_added='2007-10-03 10:48:43',

products_last_modified='2007-10-03 10:48:43', products_quantity = and scenes. Ultimate Battle Z mode uses the ladder

type tournament system of fighting made popular by the fighting game Mortal Kombat. In this system,

products_retail_price = ' powers', manufacturers_id = 40, products_status = 1 WHERE (products_id = 50) LIMIT 1

 

 

However, I found a workaround that is good enough for me. I turned off EP_EXCEL_SAFE_OUTPUT and EP_PRESERVE_TABS_CR_LF . I then saved the file as a tab delimited file and ftp'd it to the /temp folder. I imported it in with EP and everything uploaded fine, with no issues. I think one of the problems was the html language in my product descriptions that was throwing things off.

 

Anyway, thanks for the help, I still can't believe I made that mistake...

 

Cheers

Lionel

Link to comment
Share on other sites

My question surrounds the tax/price option:

 

I have the changed the code to read

//**** Price includes tax? ****
// Set the EP_PRICE_WITH_TAX to
// false if you want the price that is exported to be the same value as stored in the database (no tax added).
// true if you want the tax to be added to the export price and subtracted from the import price.
define ('EP_PRICE_WITH_TAX', true);  // default is false

 

But after I import - the products are displayed with the price I stated (which includes tax) but if I go check on the product it has not selected Taxable Product. I.e. the gross and net price are the same.

 

Any ideas??

Link to comment
Share on other sites

I don't know what more explanation I can provide for this. I wrote an essay about how to make sure your temp directory is setup correctly at the top of the latest version(s) easypopulate.php file, and copied it to the docs. :thumbsup:

 

 

Hey Surfalot,

 

Finally got that temp directory fixed, and double slashes taken care of. I download the file, edit it, add the model number, then try to import it.

 

Here is a small example of what the output says:

 

File uploaded.

Temporary filename: /tmp/phpC4jKg4

User filename: EP2007Oct05-1503a.txt

Size: 12417

| 1 | V10 | 100 | 100 Updated

| 2 | V11 | 8 | 17 Updated

| 3 | V12 | 8 | 13 Updated

| 4 | V13 | 8 | 9 Updated

 

 

So, it should have updated it. Except when I visit the store, nothing has changed. I am also using Excel 2003 or open office. Any suggestions??

 

Here are the settings I am using:

 

 

EP vers: 2.76f-MS2 r1

Temp Dir:

/hsphere/local/home/aaakirks/aaafabricstoretest.com/catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: tab

Excel safe output: false

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

Link to comment
Share on other sites

I am 1st time setting up easypopulate and I am stuck with this line:

 

4. Make sure that you have a directory called catalog/temp, and that it's permissions are set to allow writes to that directory (while you're in the catalog directory, execute "chmod 777 temp").

 

My catalog directory does not have a directory called temp. Does it mean I have to create one? And about the setting up permissions stuff in this toturial...I do not get it. Can you explain in other words for me? How do I set permission like above toturial in FTP?

Teaching is learning.

Link to comment
Share on other sites

I was having problems uploading with easy populate with register globals off so I put the following in my easy populate file:

 

// fix by jb 20040815 set the strings to http post/request, since they don't seem to work on the new server, with register

//globals=off...

 

$dltype=$_REQUEST['dltype'];

$download=$_REQUEST['download'];

 

global $HTTP_POST_FILES;

 

foreach( $HTTP_POST_FILES as $varname => $fileinfo ){

$GLOBALS[$varname] = $fileinfo["tmp_name"];

$GLOBALS[$varname.'_name'] = $fileinfo["name"];

}

// end fix jb

 

 

Now I get these error:

 

Notice: Undefined index: dltype in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php on line 29

 

Notice: Undefined index: download in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php on line 30

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php:29) in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/includes/functions/sessions.php on line 68

 

 

Can someone please help me figure this out?

 

 

Here is what my easy populate file looks like:

 

<?php

 

// Current EP Version

$curver = '2.76c-MS2';

 

/*

$Id: easypopulate.php,v 2.75 2005/04/05 AL Exp $

*/

 

//

//*******************************

//*******************************

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

// **** Temp directory ****

// if you changed your directory structure from stock and do not have /catalog/temp/, then you'll need to change this accordingly.

//

// Please set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php

$tempdir = "temp/";

$tempdir2 = "temp/";

 

 

// fix by jb 20040815 set the strings to http post/request, since they don't seem to work on the new server, with register

//globals=off...

 

$dltype=$_REQUEST['dltype'];

$download=$_REQUEST['download'];

 

global $HTTP_POST_FILES;

 

foreach( $HTTP_POST_FILES as $varname => $fileinfo ){

$GLOBALS[$varname] = $fileinfo["tmp_name"];

$GLOBALS[$varname.'_name'] = $fileinfo["name"];

}

// end fix jb

 

 

//**** File Splitting Configuration ****

// we attempt to set the timeout limit longer for this script to avoid having to split the files

// NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini

// uncomment this if you are not on a safe mode server and you are getting timeouts

// set_time_limit(330);

 

// if you are splitting files, this will set the maximum number of records to put in each file.

// if you set your php.ini to a long time, you can make this number bigger

global $maxrecs;

$maxrecs = 300; // default, seems to work for most people. Reduce if you hit timeouts

//$maxrecs = 4; // for testing

 

//**** Image Defaulting ****

global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category;

 

// set them to your own default "We don't have any picture" gif

//$default_image_manufacturer = 'no_image_manufacturer.gif';

//$default_image_product = 'no_image_product.gif';

//$default_image_category = 'no_image_category.gif';

 

// or let them get set to nothing

$default_image_manufacturer = '';

$default_image_product = '';

$default_image_category = '';

 

//**** 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;

 

//**** Size of products_model in products table ****

// set this to the size of your model number field in the db. We check to make sure all models are no longer than this value.

// this prevents the database from getting fubared. Just making this number bigger won't help your database! They must match!

global $modelsize;

$modelsize = 12;

 

//**** Price includes tax? ****

// Set the v_price_with_tax to

// 0 if you want the price without the tax included

// 1 if you want the price to be defined for import & export including tax.

global $price_with_tax;

$price_with_tax =true;

 

// **** Quote -> Escape character conversion ****

// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off

// set to 1 = replace quotes with escape characters

// set to 0 = no quote replacement

global $replace_quotes;

$replace_quotes = false;

 

// **** Field Separator ****

// change this if you can't use the default of tabs

// Tab is the default, comma and semicolon are commonly supported by various progs

// Remember, if your descriptions contain this character, you will confuse EP!

global $separator;

$separator = "\t"; // tab is default

//$separator = ","; // comma

//$separator = ";"; // semi-colon

//$separator = "~"; // tilde

//$separator = "-"; // dash

//$separator = "*"; // splat

 

// **** Max Category Levels ****

// change this if you need more or fewer categories

global $max_categories;

$max_categories = 3; // 7 is default

 

// VJ product attributes begin

// **** Product Attributes ****

// change this to false, if do not want to download product attributes

global $products_with_attributes;

$products_with_attributes = true;

 

// change this to true, if you use QTYpro and want to set attributes stock with EP.

global $products_attributes_stock;

$products_attributes_stock = false;

 

 

// change this if you want to download selected product options

// this might be handy, if you have a lot of product options, and your output file exceeds 256 columns (which is the max. limit MS Excel is able to handle)

global $attribute_options_select;

//$attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options

// VJ product attributes end

 

 

 

 

// ****************************************

// Froogle configuration variables

// -- YOU MUST CONFIGURE THIS! IT WON'T WORK OUT OF THE BOX!

// ****************************************

 

// **** Froogle product info page path ****

// We can't use the tep functions to create the link, because the links will point to the admin, since that's where we're at.

// So put the entire path to your product_info.php page here

global $froogle_product_info_path;

$froogle_product_info_path = "http://www.yourdomain.com/catalog/product_info.php";

 

// **** Froogle product image path ****

// Set this to the path to your images directory

global $froogle_image_path;

$froogle_image_path = "http://www.yourdomain.com/catalog/images/";

 

// **** Froogle - search engine friendly setting

// if your store has SEARCH ENGINE FRIENDLY URLS set, then turn this to true

// I did it this way because I'm having trouble with the code seeing the constants

// that are defined in other places.

global $froogle_SEF_urls;

$froogle_SEF_urls = false;

 

 

// ****************************************

// End Froogle configuration variables

// ****************************************

 

//*******************************

//*******************************

// E N D

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

 

//*******************************

//*******************************

// S T A R T

// INITIALIZATION

//*******************************

//*******************************

 

 

require('includes/application_top.php');

require('includes/database_tables.php');

 

// >>> BEGIN REGISTER_GLOBALS

link_get_variable('download');

link_get_variable('dltype');

link_get_variable('split');

 

link_post_variable('MAX_FILE_SIZE');

link_post_variable('buttoninsert');

link_post_variable('buttonsplit');

link_post_variable('localfile');

 

link_files_variable('usrfl');

// <<< END REGISTER_GLOABLS

 

 

//*******************************

// If you are running a pre-Nov1-2002 snapshot of OSC, then we need this include line to avoid

// errors like:

// undefined function tep_get_uploaded_file

if (!function_exists(tep_get_uploaded_file)){

include ('easypopulate_functions.php');

}

//*******************************

 

// VJ product attributes begin

global $attribute_options_array;

$attribute_options_array = array();

 

if ($products_with_attributes == true) {

if (is_array($attribute_options_select) && (count($attribute_options_select) > 0)) {

foreach ($attribute_options_select as $value) {

$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'";

 

$attribute_options_values = tep_db_query($attribute_options_query);

 

if ($attribute_options = tep_db_fetch_array($attribute_options_values)){

$attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']);

}

}

} else {

$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id";

 

$attribute_options_values = tep_db_query($attribute_options_query);

 

while ($attribute_options = tep_db_fetch_array($attribute_options_values)){

$attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']);

}

}

}

// VJ product attributes end

 

global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $fileheaders;

 

// these are the fields that will be defaulted to the current values in the database if they are not found in the incoming file

global $default_these;

$default_these = array(

'v_products_image',

#'v_products_mimage',

#'v_products_bimage',

#'v_products_subimage1',

#'v_products_bsubimage1',

#'v_products_subimage2',

#'v_products_bsubimage2',

#'v_products_subimage3',

#'v_products_bsubimage3',

'v_categories_id',

'v_products_price',

'v_products_quantity',

'v_products_weight',

'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',

'v_products_upc'

);

 

//elari check default language_id from configuration table DEFAULT_LANGUAGE

$epdlanguage_query = tep_db_query("select languages_id, name from " . TABLE_LANGUAGES . " where code = '" . DEFAULT_LANGUAGE . "'");

if (tep_db_num_rows($epdlanguage_query)) {

$epdlanguage = tep_db_fetch_array($epdlanguage_query);

$epdlanguage_id = $epdlanguage['languages_id'];

$epdlanguage_name = $epdlanguage['name'];

} else {

Echo 'Strange but there is no default language to work... That may not happen, just in case... ';

}

 

$langcode = ep_get_languages();

 

if ( $dltype != '' ){

// if dltype is set, then create the filelayout. Otherwise it gets read from the uploaded file

ep_create_filelayout($dltype); // get the right filelayout for this download

}

 

//*******************************

//*******************************

// E N D

// INITIALIZATION

//*******************************

//*******************************

 

 

if ( $download == 'stream' or $download == 'tempfile' ){

//*******************************

//*******************************

// DOWNLOAD FILE

//*******************************

//*******************************

$filestring = ""; // this holds the csv file we want to download

$result = tep_db_query($filelayout_sql);

$row = tep_db_fetch_array($result);

 

// Here we need to allow for the mapping of internal field names to external field names

// default to all headers named like the internal ones

// the field mapping array only needs to cover those fields that need to have their name changed

if ( count($fileheaders) != 0 ){

$filelayout_header = $fileheaders; // if they gave us fileheaders for the dl, then use them

} else {

$filelayout_header = $filelayout; // if no mapping was spec'd use the internal field names for header names

}

//We prepare the table heading with layout values

foreach( $filelayout_header as $key => $value ){

$filestring .= $key . $separator;

}

// now lop off the trailing tab

$filestring = substr($filestring, 0, strlen($filestring)-1);

 

// set the type

if ( $dltype == 'froogle' ){

$endofrow = "\n";

} else {

// default to normal end of row

$endofrow = $separator . 'EOREOR' . "\n";

}

$filestring .= $endofrow;

 

$num_of_langs = count($langcode);

while ($row){

 

 

// if the filelayout says we need a products_name, get it

// build the long full froogle image path

$row['v_products_fullpath_image'] = $froogle_image_path . $row['v_products_image'];

// Other froogle defaults go here for now

$row['v_froogle_instock'] = 'Y';

$row['v_froogle_shipping'] = '';

$row['v_froogle_upc'] = '';

$row['v_froogle_color'] = '';

$row['v_froogle_size'] = '';

$row['v_froogle_quantitylevel'] = '';

$row['v_froogle_manufacturer_id'] = '';

$row['v_froogle_exp_date'] = '';

$row['v_froogle_product_type'] = 'OTHER';

$row['v_froogle_delete'] = '';

$row['v_froogle_currency'] = 'USD';

$row['v_froogle_offer_id'] = $row['v_products_model'];

$row['v_froogle_product_id'] = $row['v_products_model'];

 

// names and descriptions require that we loop thru all languages that are turned on in the store

foreach ($langcode as $key => $lang){

$lid = $lang['id'];

 

// for each language, get the description and set the vals

$sql2 = "SELECT *

FROM ".TABLE_PRODUCTS_DESCRIPTION."

WHERE

products_id = " . $row['v_products_id'] . " AND

language_id = '" . $lid . "'

";

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

 

// I'm only doing this for the first language, since right now froogle is US only.. Fix later!

// adding url for froogle, but it should be available no matter what

if ($froogle_SEF_urls){

// if only one language

if ($num_of_langs == 1){

$row['v_froogle_products_url_' . $lid] = $froogle_product_info_path . '/products_id/' . $row['v_products_id'];

} else {

$row['v_froogle_products_url_' . $lid] = $froogle_product_info_path . '/products_id/' . $row['v_products_id'] . '/language/' . $lid;

}

} else {

if ($num_of_langs == 1){

$row['v_froogle_products_url_' . $lid] = $froogle_product_info_path . '?products_id=' . $row['v_products_id'];

} else {

$row['v_froogle_products_url_' . $lid] = $froogle_product_info_path . '?products_id=' . $row['v_products_id'] . '&language=' . $lid;

}

}

 

$row['v_products_name_' . $lid] = $row2['products_name'];

$row['v_products_description_' . $lid] = $row2['products_description'];

$row['v_products_url_' . $lid] = $row2['products_url'];

 

// froogle advanced format needs the quotes around the name and desc

$row['v_froogle_products_name_' . $lid] = '"' . strip_tags(str_replace('"','""',$row2['products_name'])) . '"';

$row['v_froogle_products_description_' . $lid] = '"' . strip_tags(str_replace('"','""',$row2['products_description'])) . '"';

 

// support for Linda's Header Controller 2.0 here

if(isset($filelayout['v_products_head_title_tag_' . $lid])){

$row['v_products_head_title_tag_' . $lid] = $row2['products_head_title_tag'];

$row['v_products_head_desc_tag_' . $lid] = $row2['products_head_desc_tag'];

$row['v_products_head_keywords_tag_' . $lid] = $row2['products_head_keywords_tag'];

}

// end support for Header Controller 2.0

}

 

// for the categories, we need to keep looping until we find the root category

 

// start with v_categories_id

// Get the category description

// set the appropriate variable name

// if parent_id is not null, then follow it up.

// we'll populate an aray first, then decide where it goes in the

$thecategory_id = $row['v_categories_id'];

$fullcategory = ''; // this will have the entire category stack for froogle

for( $categorylevel=1; $categorylevel<$max_categories+1; $categorylevel++){

if ($thecategory_id){

$sql2 = "SELECT categories_name

FROM ".TABLE_CATEGORIES_DESCRIPTION."

WHERE

categories_id = " . $thecategory_id . " AND

language_id = " . $epdlanguage_id ;

 

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

// only set it if we found something

$temprow['v_categories_name_' . $categorylevel] = $row2['categories_name'];

// now get the parent ID if there was one

$sql3 = "SELECT parent_id

FROM ".TABLE_CATEGORIES."

WHERE

categories_id = " . $thecategory_id;

$result3 = tep_db_query($sql3);

$row3 = tep_db_fetch_array($result3);

$theparent_id = $row3['parent_id'];

if ($theparent_id != ''){

// there was a parent ID, lets set thecategoryid to get the next level

$thecategory_id = $theparent_id;

} else {

// we have found the top level category for this item,

$thecategory_id = false;

}

//$fullcategory .= " > " . $row2['categories_name'];

$fullcategory = $row2['categories_name'] . " > " . $fullcategory;

} else {

$temprow['v_categories_name_' . $categorylevel] = '';

}

}

// now trim off the last ">" from the category stack

$row['v_category_fullpath'] = substr($fullcategory,0,strlen($fullcategory)-3);

 

// temprow has the old style low to high level categories.

$newlevel = 1;

// let's turn them into high to low level categories

for( $categorylevel=6; $categorylevel>0; $categorylevel--){

if ($temprow['v_categories_name_' . $categorylevel] != ''){

$row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];

}

}

// if the filelayout says we need a manufacturers name, get it

if (isset($filelayout['v_manufacturers_name'])){

if ($row['v_manufacturers_id'] != ''){

$sql2 = "SELECT manufacturers_name

FROM ".TABLE_MANUFACTURERS."

WHERE

manufacturers_id = " . $row['v_manufacturers_id']

;

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

$row['v_manufacturers_name'] = $row2['manufacturers_name'];

}

}

 

 

// If you have other modules that need to be available, put them here

 

// VJ product attribs begin

if (isset($filelayout['v_attribute_options_id_1'])){

$languages = tep_get_languages();

 

$attribute_options_count = 1;

foreach ($attribute_options_array as $attribute_options) {

$row['v_attribute_options_id_' . $attribute_options_count] = $attribute_options['products_options_id'];

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";

 

$attribute_options_languages_values = tep_db_query($attribute_options_languages_query);

 

$attribute_options_languages = tep_db_fetch_array($attribute_options_languages_values);

 

$row['v_attribute_options_name_' . $attribute_options_count . '_' . $lid] = $attribute_options_languages['products_options_name'];

}

 

$attribute_values_query = "select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' order by products_options_values_id";

 

$attribute_values_values = tep_db_query($attribute_values_query);

 

$attribute_values_count = 1;

while ($attribute_values = tep_db_fetch_array($attribute_values_values)) {

$row['v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count] = $attribute_values['products_options_values_id'];

 

$attribute_values_price_query = "select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$row['v_products_id'] . "' and options_id = '" . (int)$attribute_options['products_options_id'] . "' and options_values_id = '" . (int)$attribute_values['products_options_values_id'] . "'";

 

$attribute_values_price_values = tep_db_query($attribute_values_price_query);

 

$attribute_values_price = tep_db_fetch_array($attribute_values_price_values);

 

$row['v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count] = $attribute_values_price['price_prefix'] . $attribute_values_price['options_values_price'];

 

//// attributes stock add start

if ( $products_attributes_stock == true ) {

$stock_attributes = $attribute_options['products_options_id'].'-'.$attribute_values['products_options_values_id'];

 

$stock_quantity_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$row['v_products_id'] . "' and products_stock_attributes = '" . $stock_attributes . "'");

$stock_quantity = tep_db_fetch_array($stock_quantity_query);

 

$row['v_attribute_values_stock_' . $attribute_options_count . '_' . $attribute_values_count] = $stock_quantity['products_stock_quantity'];

}

//// attributes stock add end

 

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$attribute_values_languages_query = "select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$attribute_values['products_options_values_id'] . "' and language_id = '" . (int)$lid . "'";

 

$attribute_values_languages_values = tep_db_query($attribute_values_languages_query);

 

$attribute_values_languages = tep_db_fetch_array($attribute_values_languages_values);

 

$row['v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $lid] = $attribute_values_languages['products_options_values_name'];

}

 

$attribute_values_count++;

}

 

$attribute_options_count++;

}

}

// VJ product attribs end

 

// this is for the separate price per customer module

if (isset($filelayout['v_customer_price_1'])){

$sql2 = "SELECT

customers_group_price,

customers_group_id

FROM

".TABLE_PRODUCTS_GROUPS."

WHERE

products_id = " . $row['v_products_id'] . "

ORDER BY

customers_group_id"

;

$result2 = tep_db_query($sql2);

$ll = 1;

$row2 = tep_db_fetch_array($result2);

while( $row2 ){

$row['v_customer_group_id_' . $ll] = $row2['customers_group_id'];

$row['v_customer_price_' . $ll] = $row2['customers_group_price'];

$row2 = tep_db_fetch_array($result2);

$ll++;

}

}

if ($dltype == 'froogle'){

// For froogle, we check the specials prices for any applicable specials, and use that price

// by grabbing the specials id descending, we always get the most recently added special price

// I'm checking status because I think you can turn off specials

$sql2 = "SELECT

specials_new_products_price

FROM

".TABLE_SPECIALS."

WHERE

products_id = " . $row['v_products_id'] . " and

status = 1 and

expires_date < CURRENT_TIMESTAMP

ORDER BY

specials_id DESC"

;

$result2 = tep_db_query($sql2);

$ll = 1;

$row2 = tep_db_fetch_array($result2);

if( $row2 ){

// reset the products price to our special price if there is one for this product

$row['v_products_price'] = $row2['specials_new_products_price'];

}

}

 

//elari -

//We check the value of tax class and title instead of the id

//Then we add the tax to price if $price_with_tax is set to 1

$row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

$row['v_tax_class_title'] = tep_get_tax_class_title($row['v_tax_class_id']);

$row['v_products_price'] = round($row['v_products_price'] +

($price_with_tax * $row['v_products_price'] * $row_tax_multiplier / 100),2);

 

 

// Now set the status to a word the user specd in the config vars

if ( $row['v_status'] == '1' ){

$row['v_status'] = $active;

} else {

$row['v_status'] = $inactive;

}

 

// remove any bad things in the texts that could confuse EasyPopulate

$therow = '';

foreach( $filelayout as $key => $value ){

//echo "The field was $key<br>";

 

$thetext = $row[$key];

// kill the carriage returns and tabs in the descriptions, they're killing me!

$thetext = str_replace("\r",' ',$thetext);

$thetext = str_replace("\n",' ',$thetext);

$thetext = str_replace("\t",' ',$thetext);

// and put the text into the output separated by tabs

$therow .= $thetext . $separator;

}

 

// lop off the trailing tab, then append the end of row indicator

$therow = substr($therow,0,strlen($therow)-1) . $endofrow;

 

$filestring .= $therow;

// grab the next row from the db

$row = tep_db_fetch_array($result);

}

 

#$EXPORT_TIME=time();

$EXPORT_TIME = strftime('%Y%b%d-%H%I');

if ($dltype=="froogle"){

$EXPORT_TIME = "FroogleEP" . $EXPORT_TIME;

} else {

$EXPORT_TIME = "EP" . $EXPORT_TIME;

}

 

// now either stream it to them or put it in the temp directory

if ($download == 'stream'){

//*******************************

// STREAM FILE

//*******************************

header("Content-type: application/vnd.ms-excel");

header("Content-disposition: attachment; filename=$EXPORT_TIME.txt");

// Changed if using SSL, helps prevent program delay/timeout (add to backup.php also)

// header("Pragma: no-cache");

if ($request_type== 'NONSSL'){

header("Pragma: no-cache");

} else {

header("Pragma: ");

}

header("Expires: 0");

echo $filestring;

die();

} else {

//*******************************

// PUT FILE IN TEMP DIR

//*******************************

$tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "$EXPORT_TIME.txt";

//unlink($tmpfname);

$fp = fopen( $tmpfname, "w+");

fwrite($fp, $filestring);

fclose($fp);

echo "You can get your file in the Tools/Files under " . $tempdir . "EP" . $EXPORT_TIME . ".txt";

die();

}

} // *** END *** download section

?>

 

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<table border="0" width="100%" cellspacing="2" cellpadding="2">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top" height="27">

<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php');?>

</table></td>

<td class="pageHeading" valign="top"><?php

echo "Easy Populate $curver - Default Language : " . $epdlanguage_name . '(' . $epdlanguage_id .')' ;

?>

 

<p class="smallText">

 

<?php

 

if ($localfile or (is_uploaded_file($usrfl) && $split==0)) {

//*******************************

//*******************************

// UPLOAD AND INSERT FILE

//*******************************

//*******************************

 

if ($usrfl){

// move the file to where we can work with it

$file = tep_get_uploaded_file('usrfl');

if (is_uploaded_file($file['tmp_name'])) {

tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir);

}

 

echo "<p class=smallText>";

echo "File uploaded. <br>";

echo "Temporary filename: " . $usrfl . "<br>";

echo "User filename: " . $usrfl_name . "<br>";

echo "Size: " . $usrfl_size . "<br>";

 

// get the entire file into an array

$readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name);

}

if ($localfile){

// move the file to where we can work with it

$file = tep_get_uploaded_file('usrfl'); $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id";

 

$attribute_options_values = tep_db_query($attribute_options_query);

 

$attribute_options_count = 1;

//while ($attribute_options = tep_db_fetch_array($attribute_options_values)){

if (is_uploaded_file($file['tmp_name'])) {

tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir);

}

 

echo "<p class=smallText>";

echo "Filename: " . $localfile . "<br>";

 

// get the entire file into an array

$readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile);

}

 

// now we string the entire thing together in case there were carriage returns in the data

$newreaded = "";

foreach ($readed as $read){

$newreaded .= $read;

}

 

// now newreaded has the entire file together without the carriage returns.

// if for some reason excel put qoutes around our EOREOR, remove them then split into rows

$newreaded = str_replace('"EOREOR"', 'EOREOR', $newreaded);

$readed = explode( $separator . 'EOREOR',$newreaded);

 

 

// Now we'll populate the filelayout based on the header row.

$theheaders_array = explode( $separator, $readed[0] ); // explode the first row, it will be our filelayout

$lll = 0;

$filelayout = array();

foreach( $theheaders_array as $header ){

$cleanheader = str_replace( '"', '', $header);

// echo "Fileheader was $header<br><br><br>";

$filelayout[ $cleanheader ] = $lll++; //

}

unset($readed[0]); // we don't want to process the headers with the data

 

// now we've got the array broken into parts by the expicit end-of-row marker.

array_walk($readed, 'walk');

 

}

 

if (is_uploaded_file($usrfl) && $split==1) {

//*******************************

//*******************************

// UPLOAD AND SPLIT FILE

//*******************************

//*******************************

// move the file to where we can work with it

$file = tep_get_uploaded_file('usrfl');

//echo "Trying to move file...";

if (is_uploaded_file($file['tmp_name'])) {

tep_copy_uploaded_file($file, DIR_FS_DOCUMENT_ROOT . $tempdir);

}

 

$infp = fopen(DIR_FS_DOCUMENT_ROOT . $tempdir . $usrfl_name, "r");

 

//toprow has the field headers

$toprow = fgets($infp,32768);

 

$filecount = 1;

 

echo "Creating file EP_Split" . $filecount . ".txt ... ";

$tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt";

$fp = fopen( $tmpfname, "w+");

fwrite($fp, $toprow);

 

$linecount = 0;

$line = fgets($infp,32768);

while ($line){

// walking the entire file one row at a time

// but a line is not necessarily a complete row, we need to split on rows that have "EOREOR" at the end

$line = str_replace('"EOREOR"', 'EOREOR', $line);

fwrite($fp, $line);

if (strpos($line, 'EOREOR')){

// we found the end of a line of data, store it

$linecount++; // increment our line counter

if ($linecount >= $maxrecs){

echo "Added $linecount records and closing file... <Br>";

$linecount = 0; // reset our line counter

// close the existing file and open another;

fclose($fp);

// increment filecount

$filecount++;

echo "Creating file EP_Split" . $filecount . ".txt ... ";

$tmpfname = DIR_FS_DOCUMENT_ROOT . $tempdir . "EP_Split" . $filecount . ".txt";

//Open next file name

$fp = fopen( $tmpfname, "w+");

fwrite($fp, $toprow);

}

}

$line=fgets($infp,32768);

}

echo "Added $linecount records and closing file...<br><br> ";

fclose($fp);

fclose($infp);

 

echo "You can download your split files in the Tools/Files under /catalog/temp/";

 

}

 

?>

</p>

 

<table width="75%" border="2">

<tr>

<td width="75%">

<FORM ENCTYPE="multipart/form-data" ACTION="easypopulate.php?split=0" METHOD=POST>

<p>

<div align = "left">

<p><b>Upload EP File</b></p>

<p>

<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="100000000">

<p></p>

<input name="usrfl" type="file" size="50">

<input type="submit" name="buttoninsert" value="Insert into db">

<br>

</p>

</div>

 

</form>

 

<FORM ENCTYPE="multipart/form-data" ACTION="easypopulate.php?split=1" METHOD=POST>

<p>

<div align = "left">

<p><b>Split EP File</b></p>

<p>

<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000000">

<p></p>

<input name="usrfl" type="file" size="50">

<input type="submit" name="buttonsplit" value="Split file">

<br>

</p>

</div>

 

</form>

 

<FORM ENCTYPE="multipart/form-data" ACTION="easypopulate.php" METHOD=POST>

<p>

<div align = "left">

<p><b>Import from Temp Dir (<? echo $tempdir; ?>)</b></p>

<p class="smallText">

<INPUT TYPE="text" name="localfile" size="50">

<input type="submit" name="buttoninsert" value="Insert into db">

<br>

</p>

</div>

 

</form>

 

 

 

 

<p><b>Download EP and Froogle Files</b></p>

 

<!-- Download file links - Add your custom fields here -->

<a href="easypopulate.php?download=stream&dltype=full">Download <b>Complete</b> tab-delimited .txt file to edit</a><br>

<a href="easypopulate.php?download=stream&dltype=priceqty">Download <b>Model/Price/Qty</b> tab-delimited .txt file to edit</a><br>

<a href="easypopulate.php?download=stream&dltype=category">Download <b>Model/Category</b> tab-delimited .txt file to edit</a><br>

<a href="easypopulate.php?download=stream&dltype=froogle">Download <b>Froogle</b> tab-delimited .txt file</a><br>

 

<!-- VJ product attributes begin //-->

<?php

if ($products_with_attributes == true) {

?>

<a href="easypopulate.php?download=stream&dltype=attrib">Download <b>Model/Attributes</b> tab-delimited .txt file</a><br>

<?php

}

?>

<!-- VJ product attributes end //-->

 

<p><b>Create EP and Froogle Files in Temp Dir (<? echo $tempdir; ?>)</b></p>

<a href="easypopulate.php?download=tempfile&dltype=full">Create Complete tab-delimited .txt file in temp dir</a><br>

<a href="easypopulate.php?download=tempfile&dltype=priceqty">Create Model/Price/Qty tab-delimited .txt file in temp dir</a><br>

<a href="easypopulate.php?download=tempfile&dltype=category">Create Model/Category tab-delimited .txt file in temp dir</a><br>

<a href="easypopulate.php?download=tempfile&dltype=froogle">Create Froogle tab-delimited .txt file in temp dir</a><br>

 

<!-- VJ product attributes begin //-->

<a href="easypopulate.php?download=tempfile&dltype=attrib">Create Model/Attributes tab-delimited .txt file in temp dir</a><br>

<!-- VJ product attributes end //-->

 

</td>

</tr>

</table>

</td>

</tr>

</table>

 

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

 

<p> </p>

<p> </p><p><br>

</p></body>

</html>

 

<?php

 

function ep_get_languages() {

$languages_query = tep_db_query("select languages_id, code from " . TABLE_LANGUAGES . " order by sort_order");

// start array at one, the rest of the code expects it that way

$ll =1;

while ($ep_languages = tep_db_fetch_array($languages_query)) {

//will be used to return language_id en language code to report in product_name_code instead of product_name_id

$ep_languages_array[$ll++] = array(

'id' => $ep_languages['languages_id'],

'code' => $ep_languages['code']

);

}

return $ep_languages_array;

};

 

function tep_get_tax_class_rate($tax_class_id) {

$tax_multiplier = 0;

$tax_query = tep_db_query("select SUM(tax_rate) as tax_rate from " . TABLE_TAX_RATES . " WHERE tax_class_id = '" . $tax_class_id . "' GROUP BY tax_priority");

if (tep_db_num_rows($tax_query)) {

while ($tax = tep_db_fetch_array($tax_query)) {

$tax_multiplier += $tax['tax_rate'];

}

}

return $tax_multiplier;

};

 

function tep_get_tax_title_class_id($tax_class_title) {

$classes_query = tep_db_query("select tax_class_id from " . TABLE_TAX_CLASS . " WHERE tax_class_title = '" . $tax_class_title . "'" );

$tax_class_array = tep_db_fetch_array($classes_query);

$tax_class_id = $tax_class_array['tax_class_id'];

return $tax_class_id ;

}

 

function print_el( $item2 ) {

echo " | " . substr(strip_tags($item2), 0, 10);

};

 

function print_el1( $item2 ) {

echo sprintf("| %'.4s ", substr(strip_tags($item2), 0, 80));

};

function ep_create_filelayout($dltype){

global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $fileheaders, $max_categories;

// depending on the type of the download the user wanted, create a file layout for it.

$fieldmap = array(); // default to no mapping to change internal field names to external.

switch( $dltype ){

case 'full':

// The file layout is dynamically made depending on the number of languages

$iii = 0;

$filelayout = array(

'v_products_model' => $iii++,

'v_products_image' => $iii++,

'v_year' => $iii++,

'v_wallet_included' => $iii++,

 

 

);

 

foreach ($langcode as $key => $lang){

$l_id = $lang['id'];

// uncomment the head_title, head_desc, and head_keywords to use

// Linda's Header Tag Controller 2.0

//echo $langcode['id'] . $langcode['code'];

$filelayout = array_merge($filelayout , array(

'v_products_name_' . $l_id => $iii++,

'v_products_description_' . $l_id => $iii++,

'v_products_url_' . $l_id => $iii++,

// 'v_products_head_title_tag_'.$l_id => $iii++,

// 'v_products_head_desc_tag_'.$l_id => $iii++,

// 'v_products_head_keywords_tag_'.$l_id => $iii++,

));

}

 

 

// uncomment the customer_price and customer_group to support multi-price per product contrib

 

// VJ product attribs begin

$header_array = array(

'v_products_price' => $iii++,

'v_products_weight' => $iii++,

'v_date_avail' => $iii++,

'v_date_added' => $iii++,

'v_products_quantity' => $iii++,

);

 

$languages = tep_get_languages();

 

global $attribute_options_array;

 

$attribute_options_count = 1;

foreach ($attribute_options_array as $attribute_options_values) {

$key1 = 'v_attribute_options_id_' . $attribute_options_count;

$header_array[$key1] = $iii++;

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$l_id = $languages[$i]['id'];

 

$key2 = 'v_attribute_options_name_' . $attribute_options_count . '_' . $l_id;

$header_array[$key2] = $iii++;

}

 

$attribute_values_query = "select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options_values['products_options_id'] . "' order by products_options_values_id";

 

$attribute_values_values = tep_db_query($attribute_values_query);

 

$attribute_values_count = 1;

while ($attribute_values = tep_db_fetch_array($attribute_values_values)) {

$key3 = 'v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key3] = $iii++;

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$l_id = $languages[$i]['id'];

 

$key4 = 'v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $l_id;

$header_array[$key4] = $iii++;

}

 

$key5 = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key5] = $iii++;

 

//// attributes stock add start

if ( $products_attributes_stock == true ) {

$key6 = 'v_attribute_values_stock_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key6] = $iii++;

}

//// attributes stock add end

 

$attribute_values_count++;

}

 

$attribute_options_count++;

}

 

$header_array['v_manufacturers_name'] = $iii++;

 

$filelayout = array_merge($filelayout, $header_array);

// VJ product attribs end

 

// build the categories name section of the array based on the number of categores the user wants to have

for($i=1;$i<$max_categories+1;$i++){

$filelayout = array_merge($filelayout, array('v_categories_name_' . $i => $iii++));

}

 

$filelayout = array_merge($filelayout, array(

'v_tax_class_title' => $iii++,

'v_status' => $iii++,

 

));

 

$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_weight as v_products_weight,

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.year as v_year,

p.wallet_included as v_wallet_included,

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_CATEGORIES." as subc,

".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc

WHERE

p.products_id = ptoc.products_id AND

ptoc.categories_id = subc.categories_id

";

 

break;

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_customer_price_1' => $iii++,

#'v_customer_group_id_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_price as v_products_price,

p.products_tax_class_id as v_tax_class_id,

p.products_quantity as v_products_quantity

FROM

".TABLE_PRODUCTS." as p

";

 

break;

 

case 'category':

// The file layout is dynamically made depending on the number of languages

$iii = 0;

$filelayout = array(

'v_products_model' => $iii++,

);

 

// build the categories name section of the array based on the number of categores the user wants to have

for($i=1;$i<$max_categories+1;$i++){

$filelayout = array_merge($filelayout, array('v_categories_name_' . $i => $iii++));

}

 

 

$filelayout_sql = "SELECT

p.products_id as v_products_id,

p.products_model as v_products_model,

subc.categories_id as v_categories_id

FROM

".TABLE_PRODUCTS." as p,

".TABLE_CATEGORIES." as subc,

".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc

WHERE

p.products_id = ptoc.products_id AND

ptoc.categories_id = subc.categories_id

";

break;

 

case 'froogle':

// this is going to be a little interesting because we need

// a way to map from internal names to external names

//

// Before it didn't matter, but with froogle needing particular headers,

// The file layout is dynamically made depending on the number of languages

$iii = 0;

$filelayout = array(

'v_froogle_products_url_1' => $iii++,

);

//

// here we need to get the default language and put

$l_id = 1; // dummy it in for now.

// foreach ($langcode as $key => $lang){

// $l_id = $lang['id'];

$filelayout = array_merge($filelayout , array(

'v_froogle_products_name_' . $l_id => $iii++,

'v_froogle_products_description_' . $l_id => $iii++,

));

// }

$filelayout = array_merge($filelayout , array(

'v_products_price' => $iii++,

'v_products_fullpath_image' => $iii++,

'v_category_fullpath' => $iii++,

'v_froogle_offer_id' => $iii++,

'v_froogle_instock' => $iii++,

'v_froogle_ shipping' => $iii++,

'v_manufacturers_name' => $iii++,

'v_froogle_ upc' => $iii++,

'v_froogle_color' => $iii++,

'v_froogle_size' => $iii++,

'v_froogle_quantitylevel' => $iii++,

'v_froogle_product_id' => $iii++,

'v_froogle_manufacturer_id' => $iii++,

'v_froogle_exp_date' => $iii++,

'v_froogle_product_type' => $iii++,

'v_froogle_delete' => $iii++,

'v_froogle_currency' => $iii++,

));

$iii=0;

$fileheaders = array(

'product_url' => $iii++,

'name' => $iii++,

'description' => $iii++,

'price' => $iii++,

'image_url' => $iii++,

'category' => $iii++,

'offer_id' => $iii++,

'instock' => $iii++,

'shipping' => $iii++,

'brand' => $iii++,

'upc' => $iii++,

'color' => $iii++,

'size' => $iii++,

'quantity' => $iii++,

'product_id' => $iii++,

'manufacturer_id' => $iii++,

'exp_date' => $iii++,

'product_type' => $iii++,

'delete' => $iii++,

'currency' => $iii++,

);

$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_weight as v_products_weight,

p.products_date_added 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_TO_CATEGORIES." as ptoc

WHERE

p.products_id = ptoc.products_id AND

ptoc.categories_id = subc.categories_id

";

break;

 

// VJ product attributes begin

case 'attrib':

$iii = 0;

$filelayout = array(

'v_products_model' => $iii++

);

 

$header_array = array();

 

$languages = tep_get_languages();

 

global $attribute_options_array;

 

$attribute_options_count = 1;

foreach ($attribute_options_array as $attribute_options_values) {

$key1 = 'v_attribute_options_id_' . $attribute_options_count;

$header_array[$key1] = $iii++;

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$l_id = $languages[$i]['id'];

 

$key2 = 'v_attribute_options_name_' . $attribute_options_count . '_' . $l_id;

$header_array[$key2] = $iii++;

}

 

$attribute_values_query = "select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options_values['products_options_id'] . "' order by products_options_values_id";

 

$attribute_values_values = tep_db_query($attribute_values_query);

 

$attribute_values_count = 1;

while ($attribute_values = tep_db_fetch_array($attribute_values_values)) {

$key3 = 'v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key3] = $iii++;

 

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$l_id = $languages[$i]['id'];

 

$key4 = 'v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $l_id;

$header_array[$key4] = $iii++;

}

 

$key5 = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key5] = $iii++;

 

//// attributes stock add start

if ( $products_attributes_stock == true ) {

$key6 = 'v_attribute_values_stock_' . $attribute_options_count . '_' . $attribute_values_count;

$header_array[$key6] = $iii++;

}

//// attributes stock add end

 

$attribute_values_count++;

}

 

$attribute_options_count++;

}

 

$filelayout = array_merge($filelayout, $header_array);

 

$filelayout_sql = "SELECT

p.products_id as v_products_id,

p.products_model as v_products_model

FROM

".TABLE_PRODUCTS." as p

";

 

break;

// VJ product attributes end

}

$filelayout_count = count($filelayout);

 

}

 

 

function walk( $item1 ) {

global $filelayout, $filelayout_count, $modelsize;

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

global $epdlanguage_id, $price_with_tax, $replace_quotes;

global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category;

global $separator, $max_categories;

// first we clean up the row of data

 

// chop blanks from each end

$item1 = ltrim(rtrim($item1));

 

// blow it into an array, splitting on the tabs

$items = explode($separator, $item1);

 

// make sure all non-set things are set to '';

// and strip the quotes from the start and end of the stings.

// escape any special chars for the database.

foreach( $filelayout as $key=> $value){

$i = $filelayout[$key];

if (isset($items[$i]) == false) {

$items[$i]='';

} else {

// Check to see if either of the magic_quotes are turned on or off;

// And apply filtering accordingly.

if (function_exists('ini_get')) {

//echo "Getting ready to check magic quotes<br>";

if (ini_get('magic_quotes_runtime') == 1){

// The magic_quotes_runtime are on, so lets account for them

// check if the last character is a quote;

// if it is, chop off the quotes.

if (substr($items[$i],-1) == '"'){

$items[$i] = substr($items[$i],2,strlen($items[$i])-4);

}

// now any remaining doubled double quotes should be converted to one doublequote

$items[$i] = str_replace('\"\"',""",$items[$i]);

if ($replace_quotes){

$items[$i] = str_replace('\"',""",$items[$i]);

$items[$i] = str_replace("\'","'",$items[$i]);

}

} else { // no magic_quotes are on

// check if the last character is a quote;

// if it is, chop off the 1st and last character of the string.

if (substr($items[$i],-1) == '"'){

$items[$i] = substr($items[$i],1,strlen($items[$i])-2);

}

// now any remaining doubled double quotes should be converted to one doublequote

$items[$i] = str_replace('""',""",$items[$i]);

if ($replace_quotes){

$items[$i] = str_replace('"',""",$items[$i]);

$items[$i] = str_replace("'","'",$items[$i]);

}

}

}

}

}

/*

if ( $items['v_status'] == $deleteit ){

// they want to delete this product.

echo "Deleting product " . $items['v_products_model'] . " from the database<br>";

// Get the ID

 

// kill in the products_to_categories

 

// Kill in the products table

 

return; // we're done deleteing!

}

*/

// 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_weight as v_products_weight,

p.products_date_added as v_date_avail,

p.products_tax_class_id as v_tax_class_id,

p.products_quantity as v_products_quantity,

p.year as v_year,

p.wallet_included as v_wallet_included,

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_TO_CATEGORIES." as ptoc

WHERE

p.products_id = ptoc.products_id AND

p.products_model = '" . $items[$filelayout['v_products_model']] . "' AND

ptoc.categories_id = subc.categories_id

";

 

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

 

 

while ($row){

// OK, since we got a row, the item already exists.

// Let's get all the data we need and fill in all the fields that need to be defaulted to the current values

// for each language, get the description and set the vals

foreach ($langcode as $key => $lang){

//echo "Inside defaulting loop";

//echo "key is $key<br>";

//echo "langid is " . $lang['id'] . "<br>";

// $sql2 = "SELECT products_name, products_description

// FROM ".TABLE_PRODUCTS_DESCRIPTION."

// WHERE

// products_id = " . $row['v_products_id'] . " AND

// language_id = '" . $lang['id'] . "'

// ";

$sql2 = "SELECT *

FROM ".TABLE_PRODUCTS_DESCRIPTION."

WHERE

products_id = " . $row['v_products_id'] . " AND

language_id = '" . $lang['id'] . "'

";

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

// Need to report from ......_name_1 not ..._name_0

$row['v_products_name_' . $lang['id']] = $row2['products_name'];

$row['v_products_description_' . $lang['id']] = $row2['products_description'];

$row['v_products_url_' . $lang['id']] = $row2['products_url'];

 

// support for Linda's Header Controller 2.0 here

if(isset($filelayout['v_products_head_title_tag_' . $lang['id'] ])){

$row['v_products_head_title_tag_' . $lang['id']] = $row2['products_head_title_tag'];

$row['v_products_head_desc_tag_' . $lang['id']] = $row2['products_head_desc_tag'];

$row['v_products_head_keywords_tag_' . $lang['id']] = $row2['products_head_keywords_tag'];

}

// end support for Header Controller 2.0

}

 

// start with v_categories_id

// Get the category description

// set the appropriate variable name

// if parent_id is not null, then follow it up.

$thecategory_id = $row['v_categories_id'];

 

for( $categorylevel=1; $categorylevel<$max_categories+1; $categorylevel++){

if ($thecategory_id){

$sql2 = "SELECT categories_name

FROM ".TABLE_CATEGORIES_DESCRIPTION."

WHERE

categories_id = " . $thecategory_id . " AND

language_id = " . $epdlanguage_id ;

 

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

// only set it if we found something

$temprow['v_categories_name_' . $categorylevel] = $row2['categories_name'];

// now get the parent ID if there was one

$sql3 = "SELECT parent_id

FROM ".TABLE_CATEGORIES."

WHERE

categories_id = " . $thecategory_id;

$result3 = tep_db_query($sql3);

$row3 = tep_db_fetch_array($result3);

$theparent_id = $row3['parent_id'];

if ($theparent_id != ''){

// there was a parent ID, lets set thecategoryid to get the next level

$thecategory_id = $theparent_id;

} else {

// we have found the top level category for this item,

$thecategory_id = false;

}

} else {

$temprow['v_categories_name_' . $categorylevel] = '';

}

}

// temprow has the old style low to high level categories.

$newlevel = 1;

// let's turn them into high to low level categories

for( $categorylevel=$max_categories+1; $categorylevel>0; $categorylevel--){

if ($temprow['v_categories_name_' . $categorylevel] != ''){

$row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];

}

}

 

if ($row['v_manufacturers_id'] != ''){

$sql2 = "SELECT manufacturers_name

FROM ".TABLE_MANUFACTURERS."

WHERE

manufacturers_id = " . $row['v_manufacturers_id']

;

$result2 = tep_db_query($sql2);

$row2 = tep_db_fetch_array($result2);

$row['v_manufacturers_name'] = $row2['manufacturers_name'];

}

 

//elari -

//We check the value of tax class and title instead of the id

//Then we add the tax to price if $price_with_tax is set to true

$row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

$row['v_tax_class_title'] = tep_get_tax_class_title($row['v_tax_class_id']);

if ($price_with_tax){

$row['v_products_price'] = round($row['v_products_price'] + ($row['v_products_price'] * $row_tax_multiplier / 100),2);

}

 

// now create the internal variables that will be used

// the $$thisvar is on purpose: it creates a variable named what ever was in $thisvar and sets the value

foreach ($default_these as $thisvar){

$$thisvar = $row[$thisvar];

}

 

$row = tep_db_fetch_array($result);

}

 

// this is an important loop. What it does is go thru all the fields in the incoming file and set the internal vars.

// Internal vars not set here are either set in the loop above for existing records, or not set at all (null values)

// the array values are handled separatly, although they will set variables in this loop, we won't use them.

foreach( $filelayout as $key => $value ){

$$key = $items[ $value ];

}

 

// so how to handle these? we shouldn't built the array unless it's been giving to us.

// The assumption is that if you give us names and descriptions, then you give us name and description for all applicable languages

foreach ($langcode as $lang){

//echo "Langid is " . $lang['id'] . "<br>";

$l_id = $lang['id'];

if (isset($filelayout['v_products_name_' . $l_id ])){

//we set dynamically the language values

$v_products_name[$l_id] = $items[$filelayout['v_products_name_' . $l_id]];

$v_products_description[$l_id] = $items[$filelayout['v_products_description_' . $l_id ]];

$v_products_url[$l_id] = $items[$filelayout['v_products_url_' . $l_id ]];

// support for Linda's Header Controller 2.0 here

if(isset($filelayout['v_products_head_title_tag_' . $l_id])){

$v_products_head_title_tag[$l_id] = $items[$filelayout['v_products_head_title_tag_' . $l_id]];

$v_products_head_desc_tag[$l_id] = $items[$filelayout['v_products_head_desc_tag_' . $l_id]];

$v_products_head_keywords_tag[$l_id] = $items[$filelayout['v_products_head_keywords_tag_' . $l_id]];

}

// end support for Header Controller 2.0

}

}

//elari... we get the tax_clas_id from the tax_title

//on screen will still be displayed the tax_class_title instead of the id....

if ( isset( $v_tax_class_title) ){

$v_tax_class_id = tep_get_tax_title_class_id($v_tax_class_title);

}

//we check the tax rate of this tax_class_id

$row_tax_multiplier = tep_get_tax_class_rate($v_tax_class_id);

 

//And we recalculate price without the included tax...

//Since it seems display is made before, the displayed price will still include tax

//This is same problem for the tax_clas_id that display tax_class_title

if ($price_with_tax){

$v_products_price = round( $v_products_price / (1 + ( $row_tax_multiplier * $price_with_tax/100) ), 4);

}

 

// if they give us one category, they give us all 6 categories

unset ($v_categories_name); // default to not set.

if ( isset( $filelayout['v_categories_name_1'] ) ){

$newlevel = 1;

for( $categorylevel=6; $categorylevel>0; $categorylevel--){

if ( $items[$filelayout['v_categories_name_' . $categorylevel]] != ''){

$v_categories_name[$newlevel++] = $items[$filelayout['v_categories_name_' . $categorylevel]];

}

}

while( $newlevel < $max_categories+1){

$v_categories_name[$newlevel++] = ''; // default the remaining items to nothing

}

}

 

if (ltrim(rtrim($v_products_quantity)) == '') {

$v_products_quantity = 1;

}

if ($v_date_avail == '') {

// $v_date_avail = "CURRENT_TIMESTAMP";

$v_date_avail = "NULL";

} else {

// we put the quotes around it here because we can't put them into the query, because sometimes

// we will use the "current_timestamp", which can't have quotes around it.

$v_date_avail = '"' . $v_date_avail . '"';

}

 

if ($v_date_added == '') {

$v_date_added = "CURRENT_TIMESTAMP";

} else {

// we put the quotes around it here because we can't put them into the query, because sometimes

// we will use the "current_timestamp", which can't have quotes around it.

$v_date_added = '"' . $v_date_added . '"';

}

 

 

// default the stock if they spec'd it or if it's blank

$v_db_status = '1'; // default to active

if ($v_status == $inactive){

// they told us to deactivate this item

$v_db_status = '0';

}

if ($zero_qty_inactive && $v_products_quantity == 0) {

// if they said that zero qty products should be deactivated, let's deactivate if the qty is zero

$v_db_status = '0';

}

 

if ($v_manufacturer_id==''){

$v_manufacturer_id="NULL";

}

 

if (trim($v_products_image)==''){

$v_products_image = $default_image_product;

}

 

if (strlen($v_products_model) > $modelsize ){

echo "<font color='red'>" . strlen($v_products_model) . $v_products_model . "... ERROR! - Too many characters in the model number.<br>

12 is the maximum on a standard OSC install.<br>

Your maximum product_model length is set to $modelsize<br>

You can either shorten your model numbers or increase the size of the field in the database.</font>";

die();

}

 

// OK, we need to convert the manufacturer's name into id's for the database

if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){

$sql = "SELECT man.manufacturers_id

FROM ".TABLE_MANUFACTURERS." as man

WHERE

man.manufacturers_name = '" . $v_manufacturers_name . "'";

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

if ( $row != '' ){

foreach( $row as $item ){

$v_manufacturer_id = $item;

}

} else {

// to add, we need to put stuff in categories and categories_description

$sql = "SELECT MAX( manufacturers_id) max FROM ".TABLE_MANUFACTURERS;

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

$max_mfg_id = $row['max']+1;

// default the id if there are no manufacturers yet

if (!is_numeric($max_mfg_id) ){

$max_mfg_id=1;

}

 

// Uncomment this query if you have an older 2.2 codebase

/*

$sql = "INSERT INTO ".TABLE_MANUFACTURERS."(

manufacturers_id,

manufacturers_name,

manufacturers_image

) VALUES (

$max_mfg_id,

'$v_manufacturers_name',

'$default_image_manufacturer'

)";

*/

 

// Comment this query out if you have an older 2.2 codebase

$sql = "INSERT INTO ".TABLE_MANUFACTURERS."(

manufacturers_id,

manufacturers_name,

manufacturers_image,

date_added,

last_modified

) VALUES (

$max_mfg_id,

'$v_manufacturers_name',

'$default_image_manufacturer',

CURRENT_TIMESTAMP,

CURRENT_TIMESTAMP

)";

$result = tep_db_query($sql);

$v_manufacturer_id = $max_mfg_id;

}

}

// if the categories names are set then try to update them

if ( isset($v_categories_name_1)){

// start from the highest possible category and work our way down from the parent

$v_categories_id = 0;

$theparent_id = 0;

for ( $categorylevel=$max_categories+1; $categorylevel>0; $categorylevel-- ){

$thiscategoryname = $v_categories_name[$categorylevel];

if ( $thiscategoryname != ''){

// we found a category name in this field

 

// now the subcategory

$sql = "SELECT cat.categories_id

FROM ".TABLE_CATEGORIES." as cat,

".TABLE_CATEGORIES_DESCRIPTION." as des

WHERE

cat.categories_id = des.categories_id AND

des.language_id = $epdlanguage_id AND

cat.parent_id = " . $theparent_id . " AND

des.categories_name = '" . $thiscategoryname . "'";

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

if ( $row != '' ){

foreach( $row as $item ){

$thiscategoryid = $item;

}

} else {

// to add, we need to put stuff in categories and categories_description

$sql = "SELECT MAX( categories_id) max FROM ".TABLE_CATEGORIES;

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

$max_category_id = $row['max']+1;

if (!is_numeric($max_category_id) ){

$max_category_id=1;

}

$sql = "INSERT INTO ".TABLE_CATEGORIES."(

categories_id,

categories_image,

parent_id,

sort_order,

date_added,

last_modified

) VALUES (

$max_category_id,

'$default_image_category',

$theparent_id,

0,

CURRENT_TIMESTAMP

,CURRENT_TIMESTAMP

)";

$result = tep_db_query($sql);

$sql = "INSERT INTO ".TABLE_CATEGORIES_DESCRIPTION."(

categories_id,

language_id,

categories_name

) VALUES (

$max_category_id,

'$epdlanguage_id',

'$thiscategoryname'

)";

$result = tep_db_query($sql);

$thiscategoryid = $max_category_id;

}

// the current catid is the next level's parent

$theparent_id = $thiscategoryid;

$v_categories_id = $thiscategoryid; // keep setting this, we need the lowest level category ID later

}

}

}

 

if ($v_products_model != "") {

// products_model exists!

array_walk($items, 'print_el');

 

// First we check to see if this is a product in the current db.

$result = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '". $v_products_model . "')");

 

if (tep_db_num_rows($result) == 0) {

// insert into products

 

$sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'";

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

$max_product_id = $row['Auto_increment'];

if (!is_numeric($max_product_id) ){

$max_product_id=1;

}

$v_products_id = $max_product_id;

echo "<font color='green'> !New Product!</font><br>";

 

$query = "INSERT INTO ".TABLE_PRODUCTS." (

 

 

products_image,

products_model,

products_price,

products_status,

products_last_modified,

products_date_added,

products_date_available,

products_tax_class_id,

products_weight,

products_quantity,

year,

wallet_included,

manufacturers_id)

VALUES (

'$v_products_image',";

 

// unmcomment these lines if you are running the image mods

/*

$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 . '", "'

*/

 

$query .=" '$v_products_model',

'$v_products_price',

'$v_db_status',

CURRENT_TIMESTAMP,

$v_date_added,

$v_date_avail,

'$v_tax_class_id',

'$v_products_weight',

'$v_products_quantity', '$v_year',

'$v_wallet_included',

'$v_manufacturer_id')

";

$result = tep_db_query($query);

} else {

// existing product, get the id from the query

// and update the product data

$row = tep_db_fetch_array($result);

$v_products_id = $row['products_id'];

echo "<font color='black'> Updated</font><br>";

$row = tep_db_fetch_array($result);

$query = 'UPDATE '.TABLE_PRODUCTS.'

SET

products_price="'.$v_products_price.

'" ,products_image="'.$v_products_image;

 

// uncomment these lines if you are running the image mods

/*

$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;

*/

 

$query .= '", products_weight="'.$v_products_weight .

'", products_tax_class_id="'.$v_tax_class_id .

'", products_date_available= ' . $v_date_avail .

', products_date_added= ' . $v_date_added .

', products_last_modified=CURRENT_TIMESTAMP

, products_quantity="' . $v_products_quantity .

'", year="' . $v_year .

'", wallet_included="' . $v_wallet_included .

'" ,manufacturers_id=' . $v_manufacturer_id .

' , products_status=' . $v_db_status . '

WHERE

(products_id = "'. $v_products_id . '")';

 

$result = tep_db_query($query);

}

 

// the following is common in both the updating an existing product and creating a new product

if ( isset($v_products_name)){

foreach( $v_products_name as $key => $name){

if ($name!=''){

$sql = "SELECT * FROM ".TABLE_PRODUCTS_DESCRIPTION." WHERE

products_id = $v_products_id AND

language_id = " . $key;

$result = tep_db_query($sql);

if (tep_db_num_rows($result) == 0) {

// nope, this is a new product description

$result = tep_db_query($sql);

$sql =

"INSERT INTO ".TABLE_PRODUCTS_DESCRIPTION."

(products_id,

language_id,

products_name,

products_description,

products_url)

VALUES (

'" . $v_products_id . "',

" . $key . ",

'" . $name . "',

'". $v_products_description[$key] . "',

'". $v_products_url[$key] . "'

)";

// support for Linda's Header Controller 2.0

if (isset($v_products_head_title_tag)){

// override the sql if we're using Linda's contrib

$sql =

"INSERT INTO ".TABLE_PRODUCTS_DESCRIPTION."

(products_id,

language_id,

products_name,

products_description,

products_url,

products_head_title_tag,

products_head_desc_tag,

products_head_keywords_tag)

VALUES (

'" . $v_products_id . "',

" . $key . ",

'" . $name . "',

'". $v_products_description[$key] . "',

'". $v_products_url[$key] . "',

'". $v_products_head_title_tag[$key] . "',

'". $v_products_head_desc_tag[$key] . "',

'". $v_products_head_keywords_tag[$key] . "')";

}

// end support for Linda's Header Controller 2.0

$result = tep_db_query($sql);

} else {

// already in the description, let's just update it

$sql =

"UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET

products_name='$name',

products_description='".$v_products_description[$key] . "',

products_url='" . $v_products_url[$key] . "'

WHERE

products_id = '$v_products_id' AND

language_id = '$key'";

// support for Lindas Header Controller 2.0

if (isset($v_products_head_title_tag)){

// override the sql if we're using Linda's contrib

$sql =

"UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET

products_name = '$name',

products_description = '".$v_products_description[$key] . "',

products_url = '" . $v_products_url[$key] ."',

products_head_title_tag = '" . $v_products_head_title_tag[$key] ."',

products_head_desc_tag = '" . $v_products_head_desc_tag[$key] ."',

products_head_keywords_tag = '" . $v_products_head_keywords_tag[$key] ."'

WHERE

products_id = '$v_products_id' AND

language_id = '$key'";

}

// end support for Linda's Header Controller 2.0

$result = tep_db_query($sql);

}

}

}

}

if (isset($v_categories_id)){

//find out if this product is listed in the category given

$result_incategory = tep_db_query('SELECT

'.TABLE_PRODUCTS_TO_CATEGORIES.'.products_id,

'.TABLE_PRODUCTS_TO_CATEGORIES.'.categories_id

FROM

'.TABLE_PRODUCTS_TO_CATEGORIES.'

WHERE

'.TABLE_PRODUCTS_TO_CATEGORIES.'.products_id='.$v_products_id.' AND

'.TABLE_PRODUCTS_TO_CATEGORIES.'.categories_id='.$v_categories_id);

 

if (tep_db_num_rows($result_incategory) == 0) {

// nope, this is a new category for this product

$res1 = tep_db_query('INSERT INTO '.TABLE_PRODUCTS_TO_CATEGORIES.' (products_id, categories_id)

VALUES ("' . $v_products_id . '", "' . $v_categories_id . '")');

} else {

// already in this category, nothing to do!

}

}

// for the separate prices per customer module

$ll=1;

 

if (isset($v_customer_price_1)){

 

if (($v_customer_group_id_1 == '') AND ($v_customer_price_1 != '')) {

echo "<font color=red>ERROR - v_customer_group_id and v_customer_price must occur in pairs</font>";

die();

}

// they spec'd some prices, so clear all existing entries

$result = tep_db_query('

DELETE

FROM

'.TABLE_PRODUCTS_GROUPS.'

WHERE

products_id = ' . $v_products_id

);

// and insert the new record

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_price .'

)'

);

}

if ($v_customer_price_2 != ''){

$result = tep_db_query('

INSERT INTO

'.TABLE_PRODUCTS_GROUPS.'

VALUES

(

' . $v_customer_group_id_2 . ',

' . $v_customer_price_2 . ',

' . $v_products_id . ',

' . $v_products_price . '

)'

);

}

if ($v_customer_price_3 != ''){

$result = tep_db_query('

INSERT INTO

'.TABLE_PRODUCTS_GROUPS.'

VALUES

(

' . $v_customer_group_id_3 . ',

' . $v_customer_price_3 . ',

' . $v_products_id . ',

' . $v_products_price . '

)'

);

}

if ($v_customer_price_4 != ''){

$result = tep_db_query('

INSERT INTO

'.TABLE_PRODUCTS_GROUPS.'

VALUES

(

' . $v_customer_group_id_4 . ',

' . $v_customer_price_4 . ',

' . $v_products_id . ',

' . $v_products_price . '

)'

);

}

 

}

 

// VJ product attribs begin

if (isset($v_attribute_options_id_1)){

$attribute_rows = 1; // master row count

 

$languages = tep_get_languages();

 

// product options count

$attribute_options_count = 1;

$v_attribute_options_id_var = 'v_attribute_options_id_' . $attribute_options_count;

 

while (isset($$v_attribute_options_id_var) && !empty($$v_attribute_options_id_var)) {

// remove product attribute options linked to this product before proceeding further

// this is useful for removing attributes linked to a product

$attributes_clean_query = "delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "'";

 

tep_db_query($attributes_clean_query);

 

$attribute_options_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "'";

 

$attribute_options_values = tep_db_query($attribute_options_query);

 

// option table update begin

if ($attribute_rows == 1) {

// insert into options table if no option exists

if (tep_db_num_rows($attribute_options_values) <= 0) {

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$v_attribute_options_name_var = 'v_attribute_options_name_' . $attribute_options_count . '_' . $lid;

 

if (isset($$v_attribute_options_name_var)) {

$attribute_options_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";

 

$attribute_options_insert = tep_db_query($attribute_options_insert_query);

}

}

} else { // update options table, if options already exists

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$v_attribute_options_name_var = 'v_attribute_options_name_' . $attribute_options_count . '_' . $lid;

 

if (isset($$v_attribute_options_name_var)) {

$attribute_options_update_lang_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";

 

$attribute_options_update_lang_values = tep_db_query($attribute_options_update_lang_query);

 

// if option name doesn't exist for particular language, insert value

if (tep_db_num_rows($attribute_options_update_lang_values) <= 0) {

$attribute_options_lang_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";

 

$attribute_options_lang_insert = tep_db_query($attribute_options_lang_insert_query);

} else { // if option name exists for particular language, update table

$attribute_options_update_query = "update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $$v_attribute_options_name_var . "' where products_options_id ='" . (int)$$v_attribute_options_id_var . "' and language_id = '" . (int)$lid . "'";

 

$attribute_options_update = tep_db_query($attribute_options_update_query);

}

}

}

}

}

// option table update end

 

// product option values count

$attribute_values_count = 1;

$v_attribute_values_id_var = 'v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count;

 

while (isset($$v_attribute_values_id_var) && !empty($$v_attribute_values_id_var)) {

$attribute_values_query = "select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$$v_attribute_values_id_var . "'";

 

$attribute_values_values = tep_db_query($attribute_values_query);

 

// options_values table update begin

if ($attribute_rows == 1) {

// insert into options_values table if no option exists

if (tep_db_num_rows($attribute_values_values) <= 0) {

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$v_attribute_values_name_var = 'v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $lid;

 

if (isset($$v_attribute_values_name_var)) {

$attribute_values_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . (int)$$v_attribute_values_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_values_name_var . "')";

 

$attribute_values_insert = tep_db_query($attribute_values_insert_query);

}

}

 

 

// insert values to pov2po table

$attribute_values_pov2po_query = "insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$$v_attribute_values_id_var . "')";

 

$attribute_values_pov2po = tep_db_query($attribute_values_pov2po_query);

} else { // update options table, if options already exists

for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

$lid = $languages[$i]['id'];

 

$v_attribute_values_name_var = 'v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $lid;

 

if (isset($$v_attribute_values_name_var)) {

$attribute_values_update_lang_query = "select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$$v_attribute_values_id_var . "' and language_id ='" . (int)$lid . "'";

 

$attribute_values_update_lang_values = tep_db_query($attribute_values_update_lang_query);

 

// if options_values name doesn't exist for particular language, insert value

if (tep_db_num_rows($attribute_values_update_lang_values) <= 0) {

$attribute_values_lang_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . (int)$$v_attribute_values_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_values_name_var . "')";

 

$attribute_values_lang_insert = tep_db_query($attribute_values_lang_insert_query);

} else { // if options_values name exists for particular language, update table

$attribute_values_update_query = "update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . $$v_attribute_values_name_var . "' where products_options_values_id ='" . (int)$$v_attribute_values_id_var . "' and language_id = '" . (int)$lid . "'";

 

$attribute_values_update = tep_db_query($attribute_values_update_query);

}

}

}

}

}

// options_values table update end

 

// options_values price update begin

$v_attribute_values_price_var = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count;

 

if (isset($$v_attribute_values_price_var) && ($$v_attribute_values_price_var != '')) {

$attribute_prices_query = "select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id ='" . (int)$$v_attribute_options_id_var . "' and options_values_id = '" . (int)$$v_attribute_values_id_var . "'";

 

$attribute_prices_values = tep_db_query($attribute_prices_query);

 

$attribute_values_price_prefix = ($$v_attribute_values_price_var < 0) ? '-' : '+';

 

// options_values_prices table update begin

// insert into options_values_prices table if no price exists

if (tep_db_num_rows($attribute_prices_values) <= 0) {

$attribute_prices_insert_query = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_id, options_id, options_values_id, options_values_price, price_prefix) values ('" . (int)$v_products_id . "', '" . (int)$$v_attribute_options_id_var . "', '" . (int)$$v_attribute_values_id_var . "', '" . (float)$$v_attribute_values_price_var . "', '" . $attribute_values_price_prefix . "')";

 

$attribute_prices_insert = tep_db_query($attribute_prices_insert_query);

} else { // update options table, if options already exists

$attribute_prices_update_query = "update " . TABLE_PRODUCTS_ATTRIBUTES . " set options_values_price = '" . $$v_attribute_values_price_var . "', price_prefix = '" . $attribute_values_price_prefix . "' where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "' and options_values_id ='" . (int)$$v_attribute_values_id_var . "'";

 

$attribute_prices_update = tep_db_query($attribute_prices_update_query);

}

}

// options_values price update end

 

//////// attributes stock add start

$v_attribute_values_stock_var = 'v_attribute_values_stock_' . $attribute_options_count . '_' . $attribute_values_count;

 

if (isset($$v_attribute_values_stock_var) && ($$v_attribute_values_stock_var != '')) {

 

$stock_attributes = $$v_attribute_options_id_var.'-'.$$v_attribute_values_id_var;

 

$attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$v_products_id . "' and products_stock_attributes ='" . $stock_attributes . "'");

 

// insert into products_stock_quantity table if no stock exists

if (tep_db_num_rows($attribute_stock_query) <= 0) {

$attribute_stock_insert_query =tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " (products_id, products_stock_attributes, products_stock_quantity) values ('" . (int)$v_products_id . "', '" . $stock_attributes . "', '" . (int)$$v_attribute_values_stock_var . "')");

 

} else { // update options table, if options already exists

$attribute_stock_insert_query = tep_db_query("update " . TABLE_PRODUCTS_STOCK. " set products_stock_quantity = '" . (int)$$v_attribute_values_stock_var . "' where products_id = '" . (int)$v_products_id . "' and products_stock_attributes = '" . $stock_attributes . "'");

 

// turn on stock tracking on products_options table

$stock_tracking_query = tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_track_stock = '1' where products_options_id = '" . (int)$$v_attribute_options_id_var . "'");

 

}

}

//////// attributes stock add end

 

 

 

 

$attribute_values_count++;

$v_attribute_values_id_var = 'v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count;

}

 

$attribute_options_count++;

$v_attribute_options_id_var = 'v_attribute_options_id_' . $attribute_options_count;

}

 

$attribute_rows++;

}

// VJ product attribs end

 

} else {

// this record was missing the product_model

array_walk($items, 'print_el');

echo "<p class=smallText>No products_model field in record. This line was not imported <br>";

echo "<br>";

}

// end of row insertion code

}

 

 

require(DIR_WS_INCLUDES . 'application_bottom.php');

?>

Link to comment
Share on other sites

Hi, I've installed the contribution and I can say that it seems to be working.

Actually i can download a csv file that is ''and comma separated.

To work in excel i choose the entire area, and then go to text in column function and convert in a normal excel file so that i can for example add products.

When i try to update that file, everything is working, i mean I see that the file is uploaded and inserted in the db but I don't find any changed in the web site.

I mean probably cause i have to convert it back to 'text','text1','text2' format but i don't know how to convert it

Do you think that this could be the reason on the "unseen changes" on the web site?

Thanks

Link to comment
Share on other sites

Hello

 

I am using 2.76F and all is working fine, and excellent for bulk uploading. I am asking this question here, just because everyone seems to be very knowledgeable here. I have categories with the same product items, and too many to do a link through admin panel. Right now, say I have a product in three categories, and I do a search for that item, I will get three listings in the search output. I would like to have the products in three categories, but only have one output listing in a search?

 

Thanks JR

Link to comment
Share on other sites

I found the solution to my problems with the following errors I was having with easy populate and the global registers off contribution:

 

Notice: Undefined index: dltype in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php on line 29

 

Notice: Undefined index: download in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php on line 30

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/easypopulate.php:29) in /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/admin/includes/functions/sessions.php on line 68

 

I put the following into my easy populate:

 

if(!isset($_REQUEST['dltype'])) $_REQUEST['dltype']='';

if(!isset($_REQUEST['download'])) $_REQUEST['download']='';

 

like this:

 

// fix by jb 20040815 set the strings to http post/request, since they don't seem to work on the new server, with register

//globals=off...

 

if(!isset($_REQUEST['dltype'])) $_REQUEST['dltype']='';

$dltype=$_REQUEST['dltype'];

if(!isset($_REQUEST['download'])) $_REQUEST['download']='';

 

$download=$_REQUEST['download'];

 

global $HTTP_POST_FILES;

 

foreach( $HTTP_POST_FILES as $varname => $fileinfo ){

$GLOBALS[$varname] = $fileinfo["tmp_name"];

$GLOBALS[$varname.'_name'] = $fileinfo["name"];

 

 

}

// end fix jb

 

While searching google, I had found someone with similar errors, but not with easy populate and just applied it to my easy populate problem so I have no idea what I am doing, but it worked. All of my error messages are gone now and easy populate is working fine now. Maybe this will help others with the same problem. Maybe someone could also explain to me what the above means.

Link to comment
Share on other sites

Hello,

 

I am using version 2.76f and ran into my first problem, and not at all with Easy Populate, but the way I have the site setup. I will have one item that maybe in three categories. When I import with EP for category one, product (A) is uploaded and shows fine. I import with EP category two, and product (A) is also contained, but when finished importing, it over writes product (A) and no longer shows in category one, only category two. I know OSC has a link feature, but there are just too many parts that will be linked. Can EP be used to import without over writting product in another category?

 

Thanks JR

Link to comment
Share on other sites

I need to install Easy Populate. I have no need for attributes.

 

I have Oscommerce 2.2 MS2 last version update before RC1.

 

What is the last version of EP that I can use that does not contain attributes that I can use.

 

Leon

Link to comment
Share on other sites

Hello,

 

I installed the ep contribution. I have tried to download an csv file and upload it again and this works fine. However as soon as I edit the csv file and try to upload it again I get the following error message:

 

No products_model field in record. This line was not imported: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

I guess it has got do do with the way I save the file. I have tried in different ways. Excel however always gives me the message: "xxx.csv can have caracteristics that are not compatible with csv. Do you want to save" (or someting alike, my excel is in spanish).

 

These are my settings:

 

EP vers: 2.76e

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: false

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: true

SPPC: false

Extra Fields: false

 

I hope somebody can help me.

 

Cheers

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