Jump to content

TropicalWebDesign

Members
  • Content count

    13
  • Joined

  • Last visited

  1. TropicalWebDesign

    Admin | Modules | Payments and Shipping lists disappear on install

    Amazon Payments Team, do you ever visit this forum to help those with issues?
  2. TropicalWebDesign

    Quickly Update Product Stock

    I figured it out and it works well.
  3. TropicalWebDesign

    Quickly Update Product Stock

    I have modified this contribution to edit the product name and added a few more columns from table 'products'. The following code works to update the columns in table 'products' but can someone help me modify the following SQL UPDATE code to add the proper code to also update field 'products_name' from table 'products_description'? I've tried, but I can't figure out how to get it to work. $sql = "UPDATE products SET products_quantity = '".$current_stock."', products_model = '".$items['model']."', products_price = '".$items_price."', products_weight = '".$items['weight']."', products_length = '".$items['length']."', products_width = '".$items['width']."', products_height = '".$items['height']."', manufacturers_id = '".$items['manufacturer']."', products_status = '".$items['active']."' WHERE products_id = $key"; Code that I tried, that didn't work: $sql = "UPDATE products, products_description SET products.products_quantity = '".$current_stock."', products.products_model = '".$items['model']."', products.products_price = '".$items_price."', products.products_weight = '".$items['weight']."', products.products_length = '".$items['length']."', products.products_width = '".$items['width']."', products.products_height = '".$items['height']."', products.manufacturers_id = '".$items['manufacturer']."', products.products_status = '".$items['active']."', products_description.products_name = '".$items['name']."' WHERE products_id = $key"; here's the syntax for the SELECT query $sql = tep_db_query("SELECT p.products_model, p.products_id, p.products_quantity, p.products_status, p.products_weight, p.products_length, p.products_width, p.products_height, p.products_price, p.manufacturers_id, pd.products_name, pd.language_id, ptc.categories_id from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and ptc.categories_id = '" . $sel_id . "' and pd.language_id = '" . (int)$lang_id . "' order by pd.products_name"); and <tr class="dataTableRow"> <td class="dataTableContent" align="center"><input type="CHECKBOX" name="stock_update[<?php echo $results['products_id'] ?>][changed]"> <input type="HIDDEN" name="stock_update[<?php echo $results['products_id'] ?>][ptc]" value="<?php echo $results['categories_id'] ?>"></td> <td class="dataTableContent" align="center"><?php echo $results['products_id'] ?></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_MODELSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][model]" value="<?php echo $results['products_model'] ?>" onChange="<?php echo $doChange?>"></td> <td class="dataTableContent" align="center"><?php echo $catman_select?></td> <td class="dataTableContent" align="left" ><input type="text" size="<?php echo QUICK_STOCK_PRODUCTNAMESIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][name]" value="<?php echo $results['products_name'] ?>" onChange="<?php echo $doChange?>"></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_WEIGHTSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][weight]" value="<?php echo $results['products_weight'] ?>" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_flt?>"></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_LENGTHSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][length]" value="<?php echo $results['products_length'] ?>" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_flt?>"></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_WIDTHSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][width]" value="<?php echo $results['products_width'] ?>" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_flt?>"></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_HEIGHTSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][height]" value="<?php echo $results['products_height'] ?>" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_flt?>"></td> <td class="dataTableContent" align="center"><input type="text" size="<?php echo QUICK_STOCK_PRICESIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][price]" value="<?php echo number_format($results['products_price'],QUICK_STOCK_PRICEDEC,'.',','); ?>" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_flt?>"></td> <td class="dataTableContent" align="center"><?php echo $results['products_quantity'] ?><input type="hidden" size="4" name="stock_update[<?php echo $results['products_id'] ?>][oldstock]" value="<?php echo $results['products_quantity'] ?>" onChange="<?php echo $doChange?>"></td> <td class="dataTableContent" width = "50px" align="center"><input type="text" size="<?php echo QUICK_STOCK_STOCKSIZE ?>" name="stock_update[<?php echo $results['products_id'] ?>][newstock]" value="0" onChange="<?php echo $doChange?>" onBlur="<?php echo $doValidate_int?>"></td> <td class="dataTableContent" align="center" ><input type="radio" name="stock_update[<?php echo $results['products_id'] ?>][active]" value="1" <?php echo $active ?> onClick="<?php echo $doChange?>"></td> <td class="dataTableContent" align="center" ><input type="radio" name="stock_update[<?php echo $results['products_id'] ?>][active]" value="0" <?php echo $inactive ?> onClick="<?php echo $doChange?>"></td> </tr>
  4. TropicalWebDesign

    Admin | Modules | Payments and Shipping lists disappear on install

    Running OScommerce 2.2MS2, actually. Attempting to install Amazon checkout version for OScommerce 2.2MS2.
  5. Admin | Modules | Payments and Shipping lists disappear on file upload Whenever I upload checkout_by_amazon.php to catalog/includes/modules/payment and checkout_by_amazon_shipping.php to catalog/includes/modules/shipping my module list in the Admin Shipping module disappears from the Admin panel and only two payment modules are left listed in the Payment panel. I am running OScommerce 2.2MS1 and PHP5. My admin directory is mysite.com/admin and catalog is mysite.com/catalog I'm not sure what else I could mention. Anyone run into this?
  6. I would like to give my customers the option of holding an order til all items are in stock for a single shipment or shipping in stock items immediately and out of stock items as they become available and calculate the charge for each shipment. Anyone know of a contribution that will fit my desires?
  7. TropicalWebDesign

    USPS module is "forcing" Express Mail option

    Mine is doing the same thing. Does anyone have a solution to this problem?
×