Jump to content

Claudia M

Member
  • Posts

    812
  • Joined

  • Last visited

  • Days Won

    13

Everything posted by Claudia M

  1. "Are you planning to keep 'site_full_address'? If not, think about just renaming the column name" I'll Just do that - change the column name. Thanks Brian
  2. Brian I want to thank you for your help on this, but I can't really think to straight right now. Knee is really hurting from physical therapy. I do have one question though. If I wanted to move all the records from the site_full_address table to the sold_locale table what would the query be? Again thanks so much
  3. All are site_full_address POST: 'status' => '883' => 0 '882' => 1 '881' => 1 '880' => 1 '879' => 1 '878' => 1 '877' => 1 '876' => 1 '875' => 1 '874' => 1 '873' => 1 '872' => 1 '871' => 1 '870' => 1 '869' => 1 '868' => 1 '867' => 1 '866' => 1 '865' => 1 '864' => 1 'sold_locale' => '865' => ClaudiasBargains.com SQL queries" 12. Hack: 1639171895.09080 --- Duration: 5311 µs [ERROR - NOT CACHED] INSERT INTO `CubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[<strong>Notice</strong>] /home/claudias/public_html/admin_Gsvj4z/sources/customers.index.inc.php:313 - Undefined variable: result','https://www.claudiasbargains.com/admin_mUF32e.php?_g=customers','mutingErrorHandler() (customers.index.inc.php:313)\nrequire() (controller.admin.session.true.inc.php:110)\ninclude() (admin_mUF32e.php:41)\n','1639171895'); 13. Hack: 1639171895.09130 --- Duration: 397 µs [NOT CACHED]
  4. The Sold Site (site_full-address) column is my old one (I also have site_full-address in Order Summary). I'm keeping it there for now to make it easier to update the Sold Locale column. (sold_locale in Customer) Each time I update null to the actual info needed I have to click save. If I try to do more than one null to info it will only save the first the othes stay at null. This also happens when I delete the info in Sold Site (then shows null) Once I get all the Store Locales inputted I'm going to delete the Sold Site column
  5. It seems I have site_full_address in both order summary and customers. So I created sold_locale for the customer and changed my code to match. It worked. I think I'm going to go thru everything and delete database fields I don't use. Thanks Brian the only thing is I have to save after I update each record. I can't do a whole page at a time
  6. I made the change above but it still isn't saving it. I use to have ajax_site_full_address in the contact details page. Could that be a problem? <fieldset><legend>{$LANG.account.contact_details}</legend> <!-- <div><label for="ajax_site_full_address">Sold Site</label><span><input type="text" id="ajax_site_full_address" name="customer[site_full_address]" value="{$CUSTOMER.site_full_address}" class="textbox"></span></div> --> <div><label for="site_full_address">Sold Site</label><span><input type="text" id="site_full_address" name="customer[site_full_address]" value="{$CUSTOMER.site_full_address}" class="textbox"></span></div> <div><label for="cust-email">Store (created) eMail</label><span><input type="text" name="customer[email]" id="cust-email" value="{$CUSTOMER.email}" class="textbox"></span></div> <div><label for="ajax_offsite_email">Offsite eMail</label><span><input type="text" id="ajax_offsite_email" name="customer[offsite_email]" value="{$CUSTOMER.offsite_email}" class="textbox"></span></div> <div><label for="ajax_site_phone">OffSite / PP Phone</label><span><input type="text" id="ajax_site_phone" name="customer[site_phone]" value="{$CUSTOMER.site_phone}" class="textbox"></span></div> <div><label for="cust-phone">{$LANG.address.phone}</label><span><input type="text" name="customer[phone]" id="cust-phone" value="{$CUSTOMER.phone}" class="textbox"></span></div> <div><label for="cust-mobile">{$LANG.address.mobile}</label><span><input type="text" name="customer[mobile]" id="cust-mobile" value="{$CUSTOMER.mobile}" class="textbox"></span></div> <div><label>{$LANG.newsletter.customer_subscribed}</label><span> In customers.index.php
  7. Thanks Brian. I'll implement it asap I implemented the changes and I get the input box, it just won't save. I get the red banner "failed to add customer" Here's what I did: admin.customer.skin: Also tried it without the strike through <td><span class="editable" name="customer[{$customer.customer_id}][site_full_address]">{$customer.site_full_address}</span></td> <td><span class="editable" name="customer[{$customer.customer_id}][site_full_address]">{$customer.site_full_address}</span></td> admin.customer.source: Also tried putting my code under the "status code" $GLOBALS['main']->successMessage($lang['customer']['notify_groups_delete']); $send_redirect = true; } if (isset($_POST['site_full_address']) && is_array($_POST['site_full_address']) && Admin::getInstance()->permissions('customers', CC_PERM_EDIT)) { foreach ($_POST['site_full_address'] as $customer_id => $site_full_address) { $result = $result || $GLOBALS['db']->update('CubeCart_customer', array('site_full_address' => $site_full_address), array('customer_id' => (int)$customer_id)); } if ($result) { $GLOBALS['main']->successMessage("Some or all sold sites updated."); } $send_redirect = true; } if (isset($_POST['status']) && is_array($_POST['status']) && Admin::getInstance()->permissions('customers', CC_PERM_EDIT)) { foreach ($_POST['status'] as $customer_id => $status) { // Delete any active session if((int)$status===0) $GLOBALS['db']->delete('CubeCart_sessions', array('customer_id' => (int)$customer_id)); $result = $GLOBALS['db']->update('CubeCart_customer', array('status' => (int)$status), array('customer_id' => (int)$customer_id)); if ($result) { $GLOBALS['main']->successMessage($lang['customer']['notify_customer_status']); } } $send_redirect = true; }
  8. Hi, I have done this in the Products Inventory field and would now like to do it with one field in the customers. I don't use Membership Groups ( See: https://forums.cubecart.com/topic/57357-customer-changed-price-on-order/#comment-249528) I have instead created a field in the order summary database called site_full_address. I have placed an input box for this under contact details on the first page of the customer form. This automatically populates in the Customer List page. After deleting my membership groups I find I have alot of empty fields on the Customer List page. Instead of going into each customer and adding the site_full_address thru the contact details input box I would like to make it editible in the Customer List page. How would I do this? Thanks in advance for any help! PS In my lines 183-189 in the admin/skin/customers.index the spans are in the wrong place. {if !empty($CONFIG.w3w)}<div><label for="address_w3w">what3words</label><span><input type="text" name="address[w3w]" id="address_w3w" value="{$ADDRESS.w3w}" class="textbox"></span></div>{/if} <div><label for="billing">{$LANG.address.billing_address}</label><span><input type="hidden" name="address[billing]" id="billing" value="{$ADDRESS.billing}" class="toggle"></div> <div><label for="default">{$LANG.address.default_delivery_address}</label><span><input type="hidden" name="address[default]" id="default" value="{$ADDRESS.default}" class="toggle"></div> <input type="hidden" name="address[address_id]" value="{$ADDRESS.address_id}"> </span></span> </fieldset> {/if}
  9. Will deleting the rows in CubeCart_pricing_group delete the retail pricing too?
  10. Would it work too if I just deleted the groups. And if I have to, delete each group by customer?
  11. Do I have to go thru each product? Or where would I go to change by group?
  12. But I have never changed the pricing for a group on a product - always used the retail pricing. I don't have time to go thru each product. I'm going to delete my member groups I guess. What's the quickest way to do that?
  13. Yes I want her to still be a member of the group. I want the retail pricing used for each group (I thought that's how it was). How do I do this? Not to be pushy but I need to get this done tonight. I'm going in for knee replacement surgery in the morning. Thanks.
  14. That must be it! I thought all products where based on Retail Pricing (15.99). However If I change Retail pricing to one of my member groups the price shows the 12.99. What do I do to fix this?
  15. Back in September I had a customer place an order for a photo frame for the price of 16.00 not including shipping. Today that same customer purchased 3 photo frames showing a price of 12.99 each. That's not the price of each item. Price is 15.99 each. How she was able to change the price, I don't know. I don't have any coupons and I don't give discounts. Any ideas? Thanks, Claudia
  16. Where do I change the colors on the progress bar 1.Basket 2. Checkout 3. Complete Thanks in advance!
  17. I'm just trying to clean up code that is not needed
  18. I have what I think may be a really dumb question. I use a HIGHLY modified foundation skin. On the category page I just use the grid view. Do I still need need all the coding like below (but maybe not limited to). Or can I use it kinda like my related products <div id="ccScroll"> <div class="product_grid_view"> Thanks in advance!
  19. The time marks were hard to read but is seems it was 16 and some minutes. Time different because of zones?
  20. I have some in red for the 9th like this: Response received (422 - Unprocessable Entity) All for the same customer. Order went thru so I guess everything worked out
  21. The GitHub says that was fixed with version 1.4.8.. I'm using version 1.4.9
×
×
  • Create New...