bsmither

Even so, searching for a customer that only exists on the Order Summary list - not in the Customer list - might only be accomplished through the admin, Orders, Search Orders tab. There you can search by customer name (although this seems to be broken at the moment - does not actually filter for the name). Anyway, I'll be working on creating a customer with no email.

That stands to reason. Is searching for a customer by their name important to your business?

What are your results (if you tried) to Create Order and just manually entering in customer details -- not first creating the customer?

Ok, my bad. You said "with phone orders of customers", I inferred you are creating an order, as in admin, Orders Create Order. This edit is for that action. In my experiments, I assumed the customer already existed. I see now that that was a bad assumption. You are also wanting to create a customer. I will experiment some more with a new Create Order and manually filling in the Customer data. For a phone order, if you need to actually Create a New Customer and enter in an address in their Addressbook, I will see what can be done about that. That may need more complicated edits.

Please try this edit. It seems to work for me. In the file /admin/skins/default/templates/orders.index.php: Near line 271, find: <div><label for="ajax_email">{$LANG.common.email}</label><span><input type="text" id="ajax_email" name="customer[email]" value="{$SUMMARY.email}" class="textbox billing required"></span></div> Change to: <div><label for="ajax_email">{$LANG.common.email}</label><span><input type="text" id="ajax_email" name="customer[email]" value="{$SUMMARY.email}" class="textbox billing"></span></div> You should now be able to submit the form at admin, Orders, Create Order with a blank email address. No emails will be sent that would otherwise be sent because there is no email address.

Won't hurt.

Please verify the version of the WorldPay module you are using. There was a syntax error in version 1.0.7 and earlier. Fixed in 1.0.8.

Sure, but assuming the screen grabs were taken at the same time, how does one get the new phrase but the other does not?

I was asking because of the phrases "Delivery Method" versus "Shipped Via".

No way to be 100% sure. So, you have a choice: spend more expensive time looking for more clues, or just keep an eye out for more of this.

That is where to change it. But instead, I found code in CC6112 that asks for a "Use this name" for the DELIVERY.method. The AIOS module doesn't use it, but, if you are willing, I would like to send you a set of code edits to the AIOS module to experiment with. The edits simply add the ability for the AIOS module to answer that question. It seems once the "Use this name" value is obtained, it gets propagated everywhere. Everywhere I have checked, that is. So, "All_In_One_Shipping" can get changed to just "Shipping" or whatever you want. Getting back to the images posted above, is the second image from admin? If not, where is it from?

In the skin template content.receipt.php: Find something that looks like: {if !empty($DELIVERY.method)} <div class="row"> <div class="small-6 medium-3 columns">{$LANG.catalogue.delivery_method}:</div> <div class="small-6 medium-9 columns">{$DELIVERY.method}{if !empty($DELIVERY.product)} ({$DELIVERY.product}){/if}</div> </div> {/if} There will at least be {$DELIVERY.method} and {$DELIVERY.product} The problem is that the $DELIVERY.method is generally the name of the folder, and are specifically wanting to overrule that if and only if the method is All_In_One_Shipping. You want the method to show if it is anything else. You might notice some anomalies: 'USPS' is the method and 'First Class' is the product. I do not know where the way it is expressed is coming from.

You installed CC5.2.16? When you say you have "migrated the store", you mean to say you did not copyany code from another version of CubeCart overwriting what was already there? If you can get into that CubeCart's admin, view the Maintenance page, Query Database tab. Don't do anything on this page - just look at the info shown just above the Query Box. This is the database server host and username. Next, click Maintenance again, Database tab. The list of tables will show the name of the database as prepended to the table name. Find CubeCart_inventory. How many records does it show? If there is 1 record, then what you are looking at via phpMyAdmin is not the same database (or database server) as what is in the /includes/global.inc.php file.

I read the response as saying an ID Code number of "0008650666" is not a valid number. You may need to apply for an account to use their online Rate calculator (if you haven't done so already). The error message may also show if there are no shipping modules that are installed/enabled. This number seems to be a 10-digit Canada Post Venture One number. As such, the next step is: * Request a CPC ID: To use Canada Post Sell Online, you'll need a CPC account. To obtain one, send an email to [email protected] requesting a CPC ID. Include the following information in the email: Company Name 10 digit Venture One ID number Address Contact name Phone number * Wait for Email Reply: Once your registration is complete, you will receive a CPC ID to access Sell Online.

Spelling error - the "web" page showing CubeCart's Order Summary for that order. Ok, so it is in the database CubeCart_order_summary.

'Hash' is a term that describes a series of letters and numbers that do not spell anything, and generally cannot be reversed into something readable. So, the 128 characters is a hash. That hash is computed by also using a randomly-generated salt value. Once the salt is generated, it is used along with the login username - they are swished around together to come up with the final hash. That final hash and the salt used to create it are databased. Then, when logging in, the username entered on the form and the databased salt are swished around in the same manner to come up with the same hash. If the computed hash matches the databased hash, then the username must be correct. Using phpMyAdmin, view the contents of the database table CubeCart_order_summary. The customer name in use at the time when the order was made is stored in this table. You are viewing an Order Summary, so you should be seeing the customer's name as it was databased when the order was made. If there is no corruption in the customer's name in the CubeCart_order_summary table, but is appearing on the wen page, then the corruption is happening somewhere in-between.

According to the code, clicking the Update Basket button will re-verify the items in the cart, and apply any discounts awarded by a coupon token entered on the form. That page is then sent back out. Shipping is not dealt with. Any other reason the form was submitted, including a change of shipping, if a coupon is to be added or removed, that is handled and that page is then sent back out. Shipping is not dealt with. Only with an auto-submitted form caused by a change in the choice of shipping is when a change in shipping is dealt with. So, I think we need to figure out how to get the radio buttons to auto-submit the form. "I switched my install to catalog mode whilst we sorted some things out." Could it be that the things that got sorted was to implement radio buttons for shipping choices?

Would that be the encoded password? The 128 character-long hash? If so, then the 'salt' value must also be the same. Catching this in CubeCart_customer is noteworthy, but what about the data in CubeCart_order_summary?

I have added something to the shopping basket and was taken to view the basket contents (?_a=basket). I am not logged in, so I get estimated shipping and taxes as applicable. At the "Your Shopping Basket" page (not yet at Checkout), I see the two choices of shipping: "Collect and Mini Standard". The placement of the radio button selector is not where I am used to seeing the shipping choices. Currently, 'Collect' is chosen (the cheapest), and when I select the other, nothing happens. I believe this to be a a problem, but not the problem. The choice of shipping does get POSTed when the Update Basket is clicked. It seems that CubeCart does not switch to using that choice. (Your initial post suggests that the problem is that the shipping selector does not appear. That is not the case for me. The shipping defaults to 'Collect" at zero-cost.) To go further, I would like to discuss troubleshooting via email.

Please use an external database utility to view CubeCart's database directly. In CubeCart_order_summary, examine the customer data for the suspect order.

For the domain having problems, log in to the hosting provider account's control panel (Cpanel?). There you will find a tool to construct and configure your database for this domain (this tool is NOT phpMyAdmin). This tool will tell you the Host:, Database Name:, and authorized UserName(s): and to create passwords for them. Currently, for some reason, the database server this CubeCart is connecting to does not like the user 'ssilberberg' or its password for either being wrong, or has no authority to use this database.

Unfortunately, this error message is so mostly off the mark as to be useless. It means that of all the shipping modules you have enabled for your store, when CubeCart asked each one to provide shipping rates, each one replied with an error (or said they had no shipping rates available based on the data supplied). With regards to CanadaPost, the common problem with eCommerce installations is that the server where they run have a firewall that is not configured to allow the module to pass outgoing traffic through port 30000. You will need to consult with your hosting provider. (We will need to confirm CanadaPost still has this method of rate request operational. I recall there being some notice about it.) Look in CubeCart's admin, Request Log to learn of the request and response made to CanadaPost.

I made a few tests. Unfortunately, I did not do the tests correctly. But just to verify, in your experience with this, was the customer logged in or not? When you choose a shipping method, other than the one currently showing (defaults to cheapest), the javascript on this page is supposed to auto-submit the View Basket form. You shouldn't need to click the "Update Basket" button when selecting the shipping method. May we have a web address to check this out?

Did you move the existing database - the actual server or the database to a new database server on the same computer - (like the post subject implies), or did you install another instance of CubeCart and want to connect to a different database, and that different database is on the same database server? Can't access the (new) database? Wherever this new database is at, you can get to it with phpMyAdmin from within that domain's control panel? If so, verify that the Database Manager in the control panel says that the domain has permission to access it, and that there is a user given privileges.

Semi-colon? I'm thinking that's a strange one, but it's not too long. Which is what I was wanting to check.