Jump to content

Claudia M

Member
  • Content Count

    616
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by Claudia M

  1. That makes sense. OK to just ignore it?
  2. When I sell an item on eBay or Etsy I setup an "account" in Cubecart using some coding and databases I created. I'll create a customer, save, then create an order from the orders tab in admin. The above errors occurred when I created two eBay orders today. I created a tab in orders to hold "special data" for these off site orders, and CC orders. Here's part of it that auto populates when I put the customer in the order. Could this cause the error? <div> <label for="customer_id"><strong>Store Customer ID</strong></label><span>{$SUMMARY.customer_id}</span></div>
  3. Hey Brian, I unchecked the code snippet as you said but I got this error today: File: [snippet_216e9674db4630b722e7937e095a8141.php] Line: [2] "SELECT `group_name` FROM `CubeCart_customer_membership` AS M INNER JOIN `CubeCart_customer_group` AS G WHERE G.`group_id` = M.`group_id` AND M.`customer_id` = ;" - 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 '' at line 1
  4. I got this error in my admin: File: [snippet_216e9674db4630b722e7937e095a8141.php] Line: [2] "SELECT `group_name` FROM `CubeCart_customer_membership` AS M INNER JOIN `CubeCart_customer_group` AS G WHERE G.`group_id` = M.`group_id` AND M.`customer_id` = ;" - 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 '' at line 1
  5. Thanks Brian. Just implemented the code and it's great!!!
  6. Would it be hard to be able to sort by group name?
  7. I have 3 group memberships - ClaudiasBargains (I haven't created that one yet) - Etsy Shop at ClaudiasBargains and Ebay at claudias_bargains. This is so I can bring the orders from those sites into CC and have one central hub I guess you'd call it. The only way a customer could be in 2, or even 3, groups is if for instance they purchased something from my Etsy shop, then from 1 0r 2 of the other groups. Come to think of it I did have that happen. They bought an item from ebay, about a year later the same item from etsy, and then later from my store. I just referenced the offsite orders in the store order. What if someone buys something from etsy and I set them up in the etsy group. Later they buy something from the store (or ebay). What if I just create another group to reflect this. CB/Etsy for instance. And then change that customers group. It would still be nice if the Group showed in the Orders list, but if it's too much trouble that's ok.
  8. I've been cleaning the files on my computer. Lots of duplicate content and some not up to date. Anyway, I came across this. It shows a sortable Group Membership column in the Customer List. Can the same be done to show a sortable Group Membership column in the Orders tab? Thanks in advance! Claudia
  9. I added the item_location code and all is working! Thank you! I'll leave the columns alone
  10. That seems to have worked. I have some DB columns I created that I would like to do the same thing - make them editable. One of them is item_location. is this what I would do before the last 2 } if (isset($product_detail_to_update['item_location'])) { $GLOBALS['db']->update('CubeCart_inventory', array('item_location' => $product_detail_to_update['item_location']), array('product_id' => $product_id)); } I created some columns in the Order Summary DB that I'm not using. Is it safe to just go into myPHPadmin and drop them? Do I have to empty them first?
  11. What am I doing wrong now!!! I edit the price of an item, save, and the product code shows null. This is my code: <td><span class="editable number" name="product[{$product.product_id}][product_code]">{$product.product_code}</span></td> <td align="center">{$product.cost_price}</td> <td><span class="editable number" name="product[{$product.product_id}][product_price]">{$product.price}</span></td> <td align="center">{$product.stock_level}</td> ---- and --- if (isset($_POST['status']) && is_array($_POST['status']) && Admin::getInstance()->permissions('products', CC_PERM_EDIT)) { // Update Status foreach ($_POST['status'] as $product_id => $status) { $GLOBALS['db']->update('CubeCart_inventory', array('status' => $status), array('product_id' => $product_id)); } if (isset($_POST['product']) && is_array($_POST['product'])) { // Update Product Code foreach ($_POST['product'] as $product_id => $product_code) { $GLOBALS['db']->update('CubeCart_inventory', array('product_code' => $product_code['product_code']), array('product_id' => $product_id)); } } if (isset($_POST['product']) && is_array($_POST['product'])) { // Update Product Price foreach ($_POST['product'] as $product_id => $product_price) { $GLOBALS['db']->update('CubeCart_inventory', array('price' => $product_price['product_price']), array('product_id' => $product_id)); } } httpredir(currentPage()); }
  12. Brian ... I can't find anything that would cause this
  13. I was thinking along those lines too. I've been over and over the code in medium-up and can't find anything. I'll take a break and check again. It works in my other skin so I'll compare them. Thanks, Brian
  14. Security Alert: Possible Cross-Site Request Forgery (CSRF). Please do not use multiple tabs/windows or the browser back button I just noticed this happening when I click my radio button to change the shipping I want to use for an order. It doesn't happen on the small display. I don't know if this is related, the footer (Customer Service, Etc. ) is suppose to go across the entire screen Thanks for any and all help I just noticed my payment options is showing
  15. I tried to implement this for the product price and the column showed null for all products. I was able to input a price but it didn't save it. Can you tell me what I'm doing wrong. Thanks in advance! In the admin skin template products.index.php, near line 78, find: Changed to: <td><span class="editable number" name="product[{$product.product_id}][product_code]">{$product.product_code}</span></td> <td align="center">{$product.cost_price}</td> <td><span class="editable number" name="product[{$product.product_id}][product_price]">{$product.product_price}</span></td> <td align="center">{$product.stock_level}</td> In the admin source code products.index.inc.php, near line 489, find: Changed to: if (isset($_POST['status']) && is_array($_POST['status']) && Admin::getInstance()->permissions('products', CC_PERM_EDIT)) { // Update Status foreach ($_POST['status'] as $product_id => $status) { $GLOBALS['db']->update('CubeCart_inventory', array('status' => $status), array('product_id' => $product_id)); } if (isset($_POST['product']) && is_array($_POST['product'])) { // Update Product Code foreach ($_POST['product'] as $product_id => $product_code) { $GLOBALS['db']->update('CubeCart_inventory', array('product_code' => $product_code['product_code']), array('product_id' => $product_id)); } } if (isset($_POST['product']) && is_array($_POST['product'])) { // Update Product Price foreach ($_POST['product'] as $product_id => $product_price) { $GLOBALS['db']->update('CubeCart_inventory', array('product_price' => $product_price['product_price']), array('product_id' => $product_id)); } } httpredir(currentPage()); }
  16. Thanks Ian, I'll get the info together and create a ticket
  17. I've had this person place quite a few orders over the last week using the same or near same name, well intials mostly, and a fake email address. Any way I can block his IP address so he can't do this. Thanks in advance, Claudia
  18. Yes there was Brian. Thanks for catching that. It has been deleted.
  19. I thinnk I got it fixed. I removed a </div> on line 93 that didn't go with anything. Small seems to be working now. I'll check the <tr>s. Thanks Brian
  20. I have enabled debug My checkout looks like this: {if isset($ITEMS)} <form action="{$VAL_SELF}" method="post" enctype="multipart/form-data" class="autosubmit" id="checkout_form"> {if $INCLUDE_CHECKOUT} {include file='templates/content.checkout.confirm.php'} {/if} <h2>{$LANG.checkout.your_basket}</h2> {include file='templates/content.checkout.medium-up.php'} {include file='templates/content.checkout.small.php'} <div class="row"> <div class="medium-8 columns text-right"> {$LANG.basket.coupon_add} </div>
  21. I've been updating my custom skin to be more in line with the stock Foundaton for version 6.2.9. I have everything close to where it needs to be, but I'm having problems with the checkout page on the small display. I use radio buttons instead of the dropdown for choosing shipping options. Back in CC5 Brian had helped me with this. I can get a shipping estimate and the options will update. Problem is if the customer chooses another option, say Parcel Select instead of the automatically selected 1st class, it will not update to the newly selected option, automatically like in checkout.medium or when I click update. It just won't update at all. Here is the code I'm using: <td class="bordr4" colspan="4"> <div class="fz-14l bold pad-top">Select your shipping method </div> <div class="fz-11t fc-darkred" style="font-weight:normal; padding-bottom:0.625rem!important;"> This may change when your actual delivery address is known</div> <ul class="no-bullet left" style="margin-top: 0rem!important;margin-bottom: 0rem!important;"> {foreach from=$SHIPPING key=group item=methods} {foreach from=$methods item=method} <li> <input name="shipping" type="radio" value="{$method.value}" id="{$method.value}" {$method.selected|replace:'selected':'checked'}><label for="{$method.value}">{$method.display}</label> </li> {/foreach} {/foreach} </ul> </td> Thanks for any and all help
×
×
  • Create New...