Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Maccan

Members
  • Content count

    5
  • Joined

  • Last visited

Everything posted by Maccan

  1. Thank you for your help, Use Swedish signs and also MS Excel to edit the CSV file, and there is no problem with the output. But finally I saw that there was space added after some of the catagory name when it came from my distributer. The name is exactly the same but with two spaces added after. And this was the cause of the problem, difficult to see when 3500 articles was imported. Could this not be checked when imported by EP? Anyway, now it works perfect, can import all 3500 without splitting the file. Thank you again for helping users in need....
  2. Thank you for the idea, did this again and found a section that covered this matter, strange did not see this first time... :blush: But after counting I see that I don´t use 32 letters in catagori name, I have now changed to 64 caracters in database. And in fact, the catagorie that made the problem was one of the shortest... Is it not correct to us "space" in catagorie names? Had duplicate problem with subcatagorie "FISKESET" Have more subcatagories that works fine like "FISKESET i LÅDA", "FISKESET TELESKOPSPÖ" BUT, if I change the subcatagorie "FISKESET" to "FISKESET NORMAL" it works!
  3. Upgraded EP to latest version and are now able to upload and download. BUT, something strange happens: Imported the file and most of it is correct. One subcategorie holds 10 products and when checking the shop there is 10 subcategories with exactly the same name holding 1 product each! This happend to about 4-5 subcategories. Example: COMPUTERS HARDWARE FAN FAN FAN FAN FAN Anyone have any ideas?
  4. Have just move my "old" shop to a new server. Everything works fine except EP. Are not able to import anything to the shop. Get this message when I try to import a split file: User filename: EP_Split1.txt Warning: explode() [function.explode]: Empty delimiter. in /home/userA/a13021xx/public_html/doman.se/admin/easypopulate.php on line 690 Warning: Invalid argument supplied for foreach() in /home/userA/a13021xx/public_html/doman.se/admin/easypopulate.php on line 693 Warning: explode() [function.explode]: Empty delimiter. in /home/userA/a1302199/public_html/doman.se/admin/easypopulate.php on line 1208 Warning: array_walk() [function.array-walk]: The argument should be an array in /home/userA/a1302199/public_html/doman.se/admin/easypopulate.php on line 2165 No products_model field in record. This line was not imported. This message is repeated several times and then nothing happens, have tried more old exported ep files and non of the works. Any ideas??
  5. Maccan

    Stock view

    Pls heeeelp!!!! :'( Have QTpro installed and tried the contrib Stockview for qtpro but it has an error. Example from stockview report: Tickets ID Tickets name Tickets model Tickets status Type Quantity Total Quantity 203 small body 07751 60 0 62/68 15 203 small body 07751 60 0 74/80 15 203 small body 07751 60 0 86/92 15 225 small tunika 07156 60 0 62/68 55 225 small tunika 07156 60 0 74/80 55 225 small tunika 07156 60 0 86/92 55 225 small tunika 07156 60 0 98/104 55 225 small tunika 07156 60 0 110/116 55 225 small tunika 07156 60 0 122/128 55 225 small tunika 07156 60 0 134/140 55 As you can see the Quantity is incorrect, it uses the total stock value for all attributes or perhaps shows no Type Quantity. But if I check the product and the page "stock" from qtpro it shows the correct quantity: Products stock: small body Storlek Quantity 62/68 4 74/80 9 86/92 2 So this page can accually see the correct quantity. I am stuck here and can not see how to get this to work.... Can anybody help me to see what code I need to get the stockview to work? *******Here are the code from the not working "stockview.php" from stockview for qtpro********************************* <?php /* $Id: stockview.php,v 1.1 2006/02/26 osCommerce StockViewer with Quantity per Attribute Contribution based on: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 - 2006 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); ?> <!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"> <script language="javascript" src="includes/general.js"></script> </head> <body> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"> <table width="700" class="infoBoxContents"> <? echo "<tr class=\"dataTableHeadingRow\"><td class=\"dataTableHeadingContent\"><b>". 'Tickets ID' . "</b></td><td class=\"dataTableHeadingContent\"><b>" . 'Tickets name' . "</b></td> <td class=\"dataTableHeadingContent\"><b>" . 'Tickets model' . "</b></td> <td class=\"dataTableHeadingContent\"><b>" . 'Tickets status' . "</b></td><td class=\"dataTableHeadingContent\"><b>" . 'Type' . "</b></td><td class=\"dataTableHeadingContent\"><b>" . 'Quantity' . "</b></td><td class=\"dataTableHeadingContent\"><b>". 'Total Quantity' . "</b></td> </tr>"; $result = mysql_query("SELECT * FROM products, products_description, products_attributes, products_options_values WHERE products.products_id = products_description.products_id and products.products_id = products_attributes.products_id and products_description.language_id = '" . $languages_id . "' and products_options_values.language_id = '" . $languages_id . "' and products_attributes.options_values_id = products_options_values.products_options_values_id ORDER BY products_description.products_name"); // echo "SELECT * FROM products, products_description, products_attributes, products_options_values WHERE products.products_id = products_description.products_id and products.products_id = products_attributes.products_id and products_description.language_id = '" . $languages_id . "' and products_attributes.options_values_id = products_options_values.products_options_values_id ORDER BY products_description.products_name"; if ($row = mysql_fetch_array($result)) { do { echo "<tr class=\"dataTableRow\" onmouseover=\"rowOverEffect(this)\" onmouseout=\"rowOutEffect(this)\" > <td class='dataTableContent'> ".$row["products_id"]."</td"; echo "<td class='dataTableContent'>".$row["products_name"]."</td>"; echo "<td class='dataTableContent'>".$row["products_model"]."</td>"; echo "<td class='dataTableContent'>".$row["products_status"]."</td>"; echo "<td class='dataTableContent'>".$row["products_options_values_name"]."</td>"; echo "<td class='dataTableContent'>".$row["options_quantity"]."</td>"; echo "<td class='dataTableContent'>".$row["products_quantity"]."</td>"; echo "</tr>"; } while($row = mysql_fetch_array($result)); } echo "</table>\n"; ?> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> </body> </html> <?php require('includes/application_bottom.php'); ?> ******************And here are the code from working "stock.php"********************** <?php /* QT Pro Version 4.1 stock.php Contribution extension to: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2004, 2005 Ralph Day Released under the GNU General Public License Based on prior works released under the GNU General Public License: QT Pro prior versions Ralph Day, October 2004 Tom Wojcik aka TomThumb 2004/07/03 based on work by Michael Coffman aka coffman FREEZEHELL - 08/11/2003 freezehell@hotmail.com Copyright © 2003 IBWO Joseph Shain, January 2003 osCommerce MS2 Copyright © 2003 osCommerce Modifications made: 11/2004 - Add input validation clean up register globals off problems use table name constant for products_stock instead of hard coded table name 03/2005 - Change $_SERVER to $HTTP_SERVER_VARS for compatibility with older php versions ******************************************************************************** *********** QT Pro Stock Add/Update This is a page to that is linked from the osCommerce admin categories page when an item is selected. It displays a products attributes stock and allows it to be updated. ******************************************************************************** *********** $Id: stock.php,v 1.00 2003/08/11 14:40:27 IBWO Exp $ Enhancement module for osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Credit goes to original QTPRO developer. Attributes Inventory - FREEZEHELL - 08/11/2003 freezehell@hotmail.com Copyright © 2003 IBWO Released under the GNU General Public License */ require('includes/application_top.php'); if ($HTTP_SERVER_VARS['REQUEST_METHOD']=="GET") { $VARS=$_GET; } else { $VARS=$_POST; } if ($VARS['action']=="Add") { $inputok = true; if (!(is_numeric($VARS['product_id']) and ($VARS['product_id']==(int)$VARS['product_id']))) $inputok = false; while(list($v1,$v2)=each($VARS)) { if (preg_match("/^option(\d+)$/",$v1,$m1)) { if (is_numeric($v2) and ($v2==(int)$v2)) $val_array[]=$m1[1]."-".$v2; else $inputok = false; } } if (!(is_numeric($VARS['quantity']) and ($VARS['quantity']==(int)$VARS['quantity']))) $inputok = false; if (($inputok)) { sort($val_array, SORT_NUMERIC); $val=join(",",$val_array); $q=tep_db_query("select products_stock_id as stock_id from " . TABLE_PRODUCTS_STOCK . " where products_id=" . (int)$VARS['product_id'] . " and products_stock_attributes='" . $val . "' order by products_stock_attributes"); if (tep_db_num_rows($q)>0) { $stock_item=tep_db_fetch_array($q); $stock_id=$stock_item[stock_id]; if ($VARS['quantity']=intval($VARS['quantity'])) { tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity=" . (int)$VARS['quantity'] . " where products_stock_id=$stock_id"); } else { tep_db_query("delete from " . TABLE_PRODUCTS_STOCK . " where products_stock_id=$stock_id"); } } else { tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " values (0," . (int)$VARS['product_id'] . ",'$val'," . (int)$VARS['quantity'] . ")"); } $q=tep_db_query("select sum(products_stock_quantity) as summa from " . TABLE_PRODUCTS_STOCK . " where products_id=" . (int)$VARS['product_id'] . " and products_stock_quantity>0"); $list=tep_db_fetch_array($q); $summa= (empty($list[summa])) ? 0 : $list[summa]; tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity=$summa where products_id=" . (int)$VARS['product_id']); if (($summa<1) && (STOCK_ALLOW_CHECKOUT == 'false')) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status='0' where products_id=" . (int)$VARS['product_id']); } } } if ($VARS['action']=="Update") { tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity=" . (int)$VARS['quantity'] . " where products_id=" . (int)$VARS['product_id']); if (($VARS['quantity']<1) && (STOCK_ALLOW_CHECKOUT == 'false')) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status='0' where products_id=" . (int)$VARS['product_id']); } } if ($VARS['action']=="Apply to all") { } $q=tep_db_query($sql="select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from ". "products_description, products_attributes,products_options,products_options_values where ". "products_attributes.products_id=products_description.products_id and ". "products_attributes.products_id=" . (int)$VARS['product_id'] . " and ". "products_attributes.options_id=products_options.products_options_id and ". "products_attributes.options_values_id=products_options_values.products_opti ons_values_id and ". "products_description.language_id=" . (int)$languages_id . " and ". "products_options_values.language_id=" . (int)$languages_id . " and products_options.products_options_track_stock=1 and ". "products_options.language_id=" . (int)$languages_id . " order by products_attributes.options_id, products_attributes.options_values_id"); //list($product_name,$option_name,$option_id,$value,$value_id) if (tep_db_num_rows($q)>0) { $flag=1; while($list=tep_db_fetch_array($q)) { $options[$list[_option_id]][]=array($list[_value],$list[_value_id]); $option_names[$list[_option_id]]=$list[_option]; $product_name=$list[products_name]; } } else { $flag=0; $q=tep_db_query("select products_quantity,products_name from " . TABLE_PRODUCTS . " p,products_description pd where pd.products_id=" . (int)$VARS['product_id'] . " and p.products_id=" . (int)$VARS['product_id']); $list=tep_db_fetch_array($q); $db_quantity=$list[products_quantity]; $product_name=stripslashes($list[products_name]); } ?> <!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"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo PRODUCTS_STOCK.": $product_name"; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><form action="<? echo $PHP_SELF;?>" method=get> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <?php $title_num=1; if ($flag) { while(list($k,$v)=each($options)) { echo "<td class=\"dataTableHeadingContent\"> $option_names[$k]</td>"; $title[$title_num]=$k; } echo "<td class=\"dataTableHeadingContent\"><span class=smalltext>Quantity</span></td><td width=\"100%\"> </td>"; echo "</tr>"; $q=tep_db_query("select * from " . TABLE_PRODUCTS_STOCK . " where products_id=" . $VARS['product_id'] . " order by products_stock_attributes"); while($rec=tep_db_fetch_array($q)) { $val_array=explode(",",$rec[products_stock_attributes]); echo "<tr>"; foreach($val_array as $val) { if (preg_match("/^(\d+)-(\d+)$/",$val,$m1)) { echo "<td class=smalltext> ".tep_values_name($m1[2])."</td>"; } else { echo "<td> </td>"; } } for($i=0;$i<sizeof($options)-sizeof($val_array);$i++) { echo "<td> </td>"; } echo "<td class=smalltext> $rec[products_stock_quantity]</td><td> </td></tr>"; } echo "<tr>"; reset($options); $i=0; while(list($k,$v)=each($options)) { echo "<td class=dataTableHeadingRow><select name=option$k>"; foreach($v as $v1) { echo "<option value=".$v1[1].">".$v1[0]; } echo "</select></td>"; $i++; } } else { $i=1; echo "<td class=dataTableHeadingContent>Quantity</td>"; } echo "<td class=dataTableHeadingRow><input type=text name=quantity size=4 value=\"" . $db_quantity . "\"><input type=hidden name=product_id value=\"" . $VARS['product_id'] . "\"> </td><td width=\"100%\" class=dataTableHeadingRow> <input type=submit name=action value=" . ($flag?"Add":"Update") . "> </td><td width=\"100%\" class=dataTableHeadingRow> </td>"; ?> </tr> </table></td> </tr> </table> </form></td> </tr> <tr><td><br> <?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, '', 'NONSSL') . '" class="menuBoxContentLink">Back to Products Category</a> <a href="' . tep_href_link(FILENAME_STATS_LOW_STOCK_ATTRIB, '', 'NONSSL') . '" class="menuBoxContentLink">Back to Low Stock Report for Attributes</a>';?> </td></tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
×