Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tsroque

Banned
  • Posts

    21
  • Joined

  • Last visited

Profile Information

  • Real Name
    Troque
  • Location
    Houston

tsroque's Achievements

  1. I too am curious if anyone found a fix for this problem. My Points are not showing in PayPal. Thanks!
  2. This thread was created to support contribution: http://addons.oscommerce.com/info/6717 =========================================================================== Original article is at: http://www.aspfree.com/c/a/Database/Converting-Your-Excel-Worksheet-into-a-Working-MySQL-Database/ ://http://www.aspfree.com/c/a/Database...ySQL-Database/ You can only export one worksheet at a time to your MySQL database. Your worksheet should be free from images, colors, wrapping text, and fancy fonts. The first row is considered your Heading row starting in A1. Steps to import a CSV file created in Excel into a MySQL table for a MySQL database stored on a server (not XAMPP localhost): 1. Create your Excel file using the EXACT field names as in your MySQL table. If you are importing into a table with many field names, you may want to EXPORT the table first, open in Excel and save it as your template. If you are adding new data, make sure you delete any data that might have exported with your field names. If your table has a Primary Key, it should be the first field listed. If you have it set to auto_increments, leave it blank in your Excel file. 2. Save it as a CSV file (SUGGESTION: you may want to save the Workbook the same name as your table in the same format. Ex: products_attributes). Go to File -> save as “CSV (Comma delimited).” If there is a warning that says “Do you want to keep the workbook in this format?” Click “YES” and close the workbook. Click “NO” if there is a warning that asks “Do you want to save the changes made to yourworkbook.csv?” 3. Then go to http://csv2sql.evandavey.com/. This will convert csv data into MySQL insert statements. Table Name: Type the EXACT table name you are importing to. CSV File: Browse to the location of the CSV file you have saved in the above steps. Mode: “Insert Statements” If you are updating existing data, choose Updating Statement. Primary Key Field (Update Only): leave blank. After all are set, click “GO” Copy the created statement(s). You can leave off the following: “-- Generated by http://csv2sql.com online CSV to SQL converter” 4. Go to phpMyAdmin >> select your database 5. Click on the “SQL” tab at the top 6. Paste your statement(s) in the “Run SQL query/queries…” box 7. Click “GO”
  3. Hi Everyone - If you have the following 2 contributions installed, and would like to combine them, here's how I got it to work with the help of WDEPOT and Jan Zonjee HISTORY: I wanted to show my customers the discount they were receiving off MSRP, so I used WDEPOT's Display MSRP & Savings contribution http://www.oscommerce.com/community/contri...ns,3574/page,25 which works great! Then I decided to offer a bulk discount that was automatic so I still had the option to run coupon ads for marketing purposes, so I installed the Quantity Price Breaks Per Product contribution http://www.oscommerce.com/community/contributions,1242. ISSUES & SOLUTIONS: 1) Two price tables are displayed. Thought it would be nice to have MSRP displayed in the QPBPP table 2) The % discount is calculating off Products_Price instead of the new field, Products_MSRP. When calculated off MSRP, my customers can see how large of a discount I'm giving. Well, I got the Product_Info.php page to display correctly, ran it through Sandbox in every combo with Discount Coupon Codes and everything works fine. The steps are below, but I had to forge the Admin/Categories.php file because I can't figure out how to get the MSRP in the QPBPP table and the table to show me the % discount based on MSRP, but as long as my customers are seeing the right information, I'm posting this to see if anyone else can come up with that little fix. :) ******************************************************************************* PriceFormatter.php FIND //Collect required data $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; CHANGE TO: //Collect required data $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_msrp, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; ******************************************************************************* FIND: //Compose cachable structure $price_formatter_data = array( 'products_price' => $product_info['products_price'], CHANGE TO: //Compose cachable structure $price_formatter_data = array( 'products_msrp' => $product_info['products_msrp'], 'products_price' => $product_info['products_price'], ******************************************************************************* FIND: //Add to cache $pfs->addPriceFormatterData(tep_get_prid($product_id), $price_formatter_data); } else { // data from product listing //Compose cachable structure $price_formatter_data = array( 'products_price' => $listing['products_price'], CHANGE TO: //Add to cache $pfs->addPriceFormatterData(tep_get_prid($product_id), $price_formatter_data); } else { // data from product listing //Compose cachable structure $price_formatter_data = array( 'products_msrp' => $listing['products_msrp'], 'products_price' => $listing['products_price'], ******************************************************************************* FIND: //Assign members $this->thePrice = $price_formatter_data['products_price']; CHANGE TO: //Assign members $this->theMSRP = $price_formatter_data['products_msrp']; $this->thePrice = $price_formatter_data['products_price']; ******************************************************************************* FIND: function getPrice() { return $this->thePrice; } CHANGE TO: function getMSRP() { return $this->theMSRP; } function getPrice() { return $this->thePrice; } ******************************************************************************* FIND: $this->getDiscountSaving($this->thePrice, $this->specialPrice) CHANGE TO: $this->getDiscountSaving($this->theMSRP, $this->specialPrice) ******************************************************************************* This is to show the MSRP in the table: FIND: $lc_text .= '<tr valign="top"><td width="120" class="infoBoxHeading">' . TEXT_ENTER_QUANTITY .'</td><td align="center" class="infoBoxHeading">1+' CHANGE TO: $lc_text .= '<tr valign="top"><td width="120" class="infoBoxHeading">' . TEXT_ENTER_QUANTITY .'</td><td width="120" class="infoBoxHeading">' . TEXT_PRODUCTS_MSRP .'</td><td align="center" class="infoBoxHeading">1+' ******************************************************************************* This is to show the MSRP in the table: FIND: $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_PRICE_PER_PIECE . '</td><td align="center" width="50" class="infoBoxContents">'; CHANGE TO: $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_PRICE_PER_PIECE . '</td><td width="120" class="infoBoxContents">' . $currencies->display_price($this->theMSRP, tep_get_tax_rate($this->taxClass)) . '</td><td align="center" width="50" class="infoBoxContents">'; ******************************************************************************* This is to show the MSRP in the table: FIND: // Begin saving calculation $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_SAVINGS . '</td>'; CHANGE TO: // Begin saving calculation $lc_text .= '<tr valign="top"><td width="120" class="infoBoxContents">' . TEXT_SAVINGS . '</td><td width="120" class="infoBoxContents"></td>'; ******************************************************************************* FIND: } else { $lc_text .= '<td align="center" class="infoBoxContents">- </td>'; } CHANGE TO: } else { $lc_text .= '<td align="center" class="infoBoxContents">' . $this->getDiscountSaving($this->theMSRP, $this->thePrice) .'</td>'; } ******************************************************************************* PriceFormatterStore.php FIND: $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id in (" . $product_id_list . ")" . " and pd.language_id = '". (int)$languages_id ."'"; CHANGE TO: $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_msrp, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id in (" . $product_id_list . ")" . " and pd.language_id = '". (int)$languages_id ."'"; ******************************************************************************* ADMIN/CATEGORIES.php FIND <td class="pageHeading"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . $pInfo->products_name; ?></td> <?php $pricing = '<table class="PriceList" border="0" width="100%" cellspacing="0" cellpadding="0">'; $new_price = tep_get_products_special_price($HTTP_GET_VARS['pID']); if ($pInfo->products_msrp > $pInfo->products_price) $pricing .= '<tr><td>' . TEXT_PRODUCTS_MSRP . '</td><td align=right>' . $currencies->format($pInfo->products_msrp) . '</td><td></td></tr>'; $pricing .= '<tr><td>' . TEXT_PRODUCTS_OUR_PRICE . '</td><td align=right>' . $currencies->format($pInfo->products_price) . '</td><td></td></tr>'; if ($new_price != '') {$pricing .= '<tr class="specialPrice"><td>' . TEXT_PRODUCTS_SALE . '</td><td align=right>' . $currencies->format($new_price) . '</td><td></td></tr>';} if ($pInfo->products_msrp > $pInfo->products_price) {if ($new_price != '') {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_msrp - $new_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($new_price / $pInfo->products_msrp) * 100)) . '%)</td></tr>';} else {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_msrp - $pInfo->products_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($pInfo->products_price / $pInfo->products_msrp) * 100)) . '%)</td></tr>';}} else {if ($new_price != '') {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_price - $new_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($new_price / $pInfo->products_price) * 100)) . '%)</td></tr>';}} $pricing .= '</td>'; ?> <td align="right" valign="top" width="27%"><!--<?php echo $pricing; ?></td> CHANGE TO: <!--BOF MSRP Mod <td class="pageHeading"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . $pInfo->products_name; ?></td> <?php $pricing = '<table class="PriceList" border="0" width="100%" cellspacing="0" cellpadding="0">'; $new_price = tep_get_products_special_price($HTTP_GET_VARS['pID']); if ($pInfo->products_msrp > $pInfo->products_price) $pricing .= '<tr><td>' . TEXT_PRODUCTS_MSRP . '</td><td align=right>' . $currencies->format($pInfo->products_msrp) . '</td><td></td></tr>'; $pricing .= '<tr><td>' . TEXT_PRODUCTS_OUR_PRICE . '</td><td align=right>' . $currencies->format($pInfo->products_price) . '</td><td></td></tr>'; if ($new_price != '') {$pricing .= '<tr class="specialPrice"><td>' . TEXT_PRODUCTS_SALE . '</td><td align=right>' . $currencies->format($new_price) . '</td><td></td></tr>';} if ($pInfo->products_msrp > $pInfo->products_price) {if ($new_price != '') {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_msrp - $new_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($new_price / $pInfo->products_msrp) * 100)) . '%)</td></tr>';} else {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_msrp - $pInfo->products_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($pInfo->products_price / $pInfo->products_msrp) * 100)) . '%)</td></tr>';}} else {if ($new_price != '') {$pricing .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . $currencies->format($pInfo->products_price - $new_price) . '</td><td class="SavingsPercent"> ('. number_format(100 - (($new_price / $pInfo->products_price) * 100)) . '%)</td></tr>';}} $pricing .= '</td>'; ?> <td align="right" valign="top" width="27%"><!--<?php echo $pricing; ?></td> EOF MSRP Mod--> *******************************************************************************
  4. Actually, I meant to say that it's calculating correctly, but it's calculating off the 1st initial discount. I sell my products at a 40% discount, and would like it to calculate based on MSRP. I'm guessing the calculation takes place in the PriceFormatter.php file... Does anyone know how to change this code? I still want 1+ to be products_price... I just need the Savings % field (i think it's Price_Break) to be calculated based on MSRP instead of products_price... HELP! Thanks! :)
  5. I have the MSRP contribution installed so now my table reflects: 1+: $52.00 2+: $50.00 4% 3+: $40.00 25% Anyways...these calculations are wrong... I would like it to say... 1+: $52.00 38% 2+: $50.00 40% 3+: $40.00 48% (I just made numbers up, but you get the point without me having to do the math) I need the table based on the MSRP instead of the my initial discount. Also, if anyone could figure out how to display the MSRP in the table, I'd appreciate it... HEADERS Qty | MSRP | 1+ | 2+ | 3+..... 2ND ROW Price | $89 | $52 | $50 | $40... 3RD ROW Savings | - | 38% | 40% | 48%.... Okay! I'm new to all this, but if I figure it out like I did to get Quantity Price Break Per Product to work with MSRP, I'll post it! :D
  6. Also, my catalog/shopping_cart.php isn't refreshing correctly. I have to log out and back in again for it to do a full refresh. Does anyone have a fix?
  7. Just curious if anyone has combined MSRP and QPBPP... I have the latest version of both, and before I mess anything else up, just thought I'd ask for someone's advice. I would like my boxes to show MSRP and calculate the % savings based on that price. My customers get a discount if they purchase 2 items or 3+ items. Right now, it's only allowing me to display and calculate my prices based on my initial discount. Plus when I installed QPBPP, it replaced the MSRP Add-on...
  8. I was wondering if anyone knows why my Admin looks like the below when I installed the CCGV5.21. The links seem to work, and when I click on another link outside the Voucher box, it goes back to normal. Did I miss an installation of a file?
  9. Admin Tool is displaying in text format. It's almost as if the Admin GUI interface is missing. Anyone else having this problem?
  10. I'm getting the same error with another contribution (Reviews in Product Display). I'm also new to PHP and MySQL, but after doing some research, it seems the way the code was written it is not compatible with MySQL 5. If you found something else out, let me know! I'd love to resolve this issue. :)
  11. Hi Adrian - I had to play around with the design a little. I actually moved all the buttons into one cell, then I merged all the cells containing the buttons into one cell and just manually spaced them. I use an editing software, so I could see the design layout. I guess it's not the "fancy" way of doing things, but it was quick and did the job. :)
  12. I'm getting the following error when I did a test run on adding a new review: I guess I'm missing something from my database? Could someone send me detail instructions on how to resolve this? Yes...I did successfully upload the product_reviews.sql fie. Thank you!!!! :rolleyes: 1054 - Unknown column 'location' in 'field list' insert into reviews (products_id, customers_id, customers_name, location, reviews_value_rating, reviews_title, reviews_rating, reviews_experience, date_added) values ('79', '4', 'Jane','Dallas', '5', '', '5', 'I currently use it.', now()) [TEP STOP]
  13. I was using the wrong key! I was using UPS' HTML key instead of the XML! That's what I get for not sleeping! :blush:
  14. When I originally loaded EP, my pics downloaded. Now, it's not... I've added a new field, but all that is working fine too. The path is still the same catalog/images/folder1/folder2/image.jpg. I'm using folder1/folder2/image.jpg. The folder1/folder2/image.jpg as text is showing in the Admin window, so i know the fields are correct after adding a new field, but now it's telling me it can't find my image. Any suggestions?
×
×
  • Create New...