JackP

Would be great to have some more plugins/extensions with an SEO focus. Rich Snippet would be very, very helpful.

I have upgraded a couple of times and although I'm technically proficient I found it required no technical skills to speak of. You just need to back up the database before perorming the upgrade. While I have never had anything happen, it is better safe than sorry. I use database backup from my server but Cube Cart does provide this functionality in their admin section. Go to your admin section, choose maintenance, click the backup tab. Backup the files, and then backup the data. Then, go to the next tab, upgrade, and follow the instructions. I found it easy to do. Generally, if you upgrade each time one is available, you will have an easier time.

If you are using Paypal Standard the button shows up and that links them to Paypal to pay. If they choose to use a credit card once at Paypal, I don't think you can force it to automatically reject credit card payments through Paypal. I use Pro, and it has a setting that requires Paypal Confirmed address, which would restrict it somewhat. Not sure if standard has that or not but it is an option. Otherwise you would need to review payments. If you are worried about fraud, there are some setting that you can use within your paypal account to reduce the risk of payments. Fraud hasn't been huge for us. After awhile, it gets pretty easy to spot a fraudulent transaction. Usually you will see multiple purchase attempts from the same person, a US/UK based address with a delivery location elsewhere (out of the country) or some other suspicious flag. If a transaction seems hinky, I will call the person up and ask them to verify the information information. Everytime I have done this the phone number was a fake and I just cancel the order.

Any ideas?

Thank you. That worked like a charm. How do you know all this stuff? I'd been looking at the Apache file all day trying to see if something was amiss

I decided I wanted to be able to run CubeCart on my local laptop so I could do code changes without impacting my current install as well as not have to FTP changes to test them. I followed the instructions here: https://support.cubecart.com/Knowledgebase/Article/View/216/42/how-do-i-move-my-cubecart-store-from-one-hosting-account-to-another to create a copy on my local server (windows, apache, php, my sql) as well as copy the database. After getting some issues resolved, I'm able to get the home page and admin to come up. The admin seems to work ok, although it seems a little slow but not unreasonable. However, anytime I try to look at a product, I get a 404 error. I also get a 404 error on on clicking on About Us, Return Policy, etc. Is there some setting that you have to refresh/renable to get these to work? Thanks. Jack

I found to remove the required of these fields I edited the .../skins/foundation/js/cubecart.validate.js file. This is a javascript file and it has flags for required validation. In this file, at about line 163, you will see something like this: 'billing[line1]': { required: true }, change required: true to required: false. That should remove the validation for required.

I find that if I put the merchant id in with single quotes (apostrophes - ') in the setup for Amazon payments, then the button will appear. This doesn't seem to be proper behavior and this is not the case for another site I have using X-cart with Amazon Payments but the configuration (and reference scripts) are different. Also, clicking the button, the window pops up but just shows the "loading" image and never comes up with the payment verification (name and password) in both sandbox and production. Occurs in both Firefox and Chrome. Not able to test in Edge as there is some other error around the Capta that I'm still researching. Has anyone gotten Amazon Payments to successfully work with the latest CC version? I am pretty sure in the prior version I got it to work a couple of times but have upgraded to the latest CC since then.

I use the All-In-One and installed a few months ago. It is pretty easy to use. 1. Install the plug in. 2. On the general tab, choose the type of shipping you want to use, such as weight based (which is what I use). 3. Go to the shipping zones and I add the zones you want to use. This is very straight forward - just name your zone, and select the countries (or states) you want the zone to be. In your case, you would create a United States zone and add all the states you want to add. 4. This will create a tab for the zone. On the tab for the zone, enter your weight ranges. Based on what you have written, you only need 1 range: 0 to whatever. The rate will be .485 per ounce. I believe there is a thickness limit, so you need to keep that in mind when calculating your rates. So, if you figure out that you can send 10 stickers in an envelope, then you would make your weight for your products 1/10th of an ounce (.01 or it might be .00625 if you are measuring by the pound). Test and experiment with it too.

Got it to work that time. I found that if I just overwrite the file using FTP, the modified code was removed from the global.php. I did this twice - kind of strange behavior. In any case, I renamed the one on the server first and then transferred it and that did the trick. Thank you for your assistance. Now, would I change that to a domain name when I move the domain over or would it stay the IP address? Jack

Yes, i was looking at a different point when I said jquery. The response seem correct to me in Chrome. Yes, I have had no problem with Firefox on multiple computers. Edge (Microsoft) has been fine. Chrome is giving me the issue from all computers.

Thanks. I appreciate your response. Unfortunately, that did not work. Looking at the cookies, not that this is the problem, you would not know anything that is going on there. There is only a jquery cookie being sent off and it has the correct information. This said, I'm not sure why version 6 of software should require a user to debug when no code has been changed (other than normal configuration items) and only looking at what I consider minimal operations. This is not a beta test. This is the latest release. I am not an expert at PHP but I was a programmer (mostly .Net, and SQL) before I got in the music business. Is the assumption is that a user of the software (and someone who hopes to contribute more at some point) knows the ins and outs of LAMP at a fairly detailed level? I really like this system as it is fast and the admin section is great. The code is clean but the lack of documentation is a hindrance (no comments, no design spec that I am aware of, object documentation, etc.), especially if it is expected for others to contribute to the project. I am hoping these issues can be resolved. I've spent the last four months configuring our products, mostly at night as I have to run the day to day business too.

Thanks. I don't use Chrome either, primarily Firefox. However, I do need to test using Chrome since some 30% of users use Chrome. I did determine that after you add to cart, and page is started to be rendered, it gets removed. When on the index page, it still shows it (until you click checkout) but then if you do anything refresh the page, it is removed. The source shows the same thing after the page is rendered, you can see the cart amount but if you look at the source it is cart is empty. I also tried on my laptop with the same result.

Testing site in Chrome. Click add to basket. Go to basket, basket is empty. Java is enabled. Any ideas? TIA. Jack

Thanks. I worked through the issue and found that if the Merchant ID is entered, the button disappears. Otherwise, it is there but nothing happens when you click it. No idea why this would happen though. Is anyone else using this? My main environment is Firefox but I also checked in MS Edge (same issue) and Chrome. Chrome doesn't even allow me to add an item to the basket (javascript is enabled).

I am using CubeCart V6 (latest update from March 16) and testing in preparation of launching the site. I have plug-ins installed for Paypal Express Checkout, All-In-One Shipping, and Amazon Payments. The Amazon Payments i not showing up on the checkout screen, even with all the tokens and such filled in (and set for sandbox). I have removed and reinstalled several times but there is no change. Does anyone have any ideas? Thanks. Jack

Does this mean that you need to edit the skin itself to remove required fields?

Any update on this? I definitely want to remove the phone number. I I also need to change some text but I figure if that is not configurable I can find the PHP that it is located and change it.

This issue is resolved. Do not see a way to mark it as such.

Thanks BsMith. Looking again what you said, I agree you mentioned this. It wasn't clear to me because it didn't mention the hashing of those values and I didn't need to reference the cached_name.

After spending some time reviewing the functions / classes in the Cube Cart source, I managed to figure it out. It took a long time though. The code is fairly clean but I'm not a PHP expert. The lack of good comments in the code is a hindrance (and disturbing for professional grade software ). Maintenance would be a nightmare for someone just coming on. In any case, for some reason, the option id and value id are getting hashed and are a field (option_identifier) in the CubeCart_option_matrix. To update the price in the CubeCart_option_assign table, I will need to determine the hash for each option_id and value_id in that table. I can then relate the CubeCart_option_matrix table, to the CubeCart_option_assign table using product_id and the option_identifier (hashed). The best approach (for me) would be to modify the CubeCart_option_assign table by adding an Option_Identifier column and use md5() in PHP to create the associated id. I will backup and test this tomorrow. This is just crazy though. There is no reason to apply a hash to those values. They are not something that needs to be encrypted (weakly encrypted at that). There are also a lot of things done in the code that would have been better off being stored procedures (or the equivalent in MySQL) rather than building and executing SQL statements from the PHP pages but I guess that is a design choice. Overall I'm very pleased with the software. The software is luxurious compared to x-cart.

Perhaps. However, since CC software is updating it, there IS something else. It is just a matter of finding it. The search continues...

Thank you. I thought about doing it as you suggest. However, there has to be a more normalized way to define the relationship. The platform is somehow defining the relationship as it updates the associated information. I seriously doubt it is splitting these text values to define the relationship. That would be a major performance hit in the database.

Thanks for your assistance. I'll try to clarify. Some products have product options. These options each have their own sku (product_code), upc, stock level, and pricing. The stock level for the options are in the table CubeCart_option_matrix. CubeCart_option_matrix also holds the product_code. So I can relate external data for the stock to the product_code in this table because the shared field is product_code. However, the price for each option is in the CubeCart_option_assign table. There is no product_code in the CubeCart_option_assign table so I have no way to know which price is for which product_code (option ). I'm trying to find a way to update the price for the options. Thanks.

Hi folks. For my CubeCart installation, I'm working on an external program that will update the stock level and price for my inventory. This is for synchronizing with our eBay, Amazon, and other marketplaces to ensure consistent pricing (we auto change prices several times a day) as well as to ensure stock levels are correct. Looking at the CubeCart database, it is a simple matter to update the CubeCart_inventory table for many products. However, some products are product options with separate sku, upc, quantities and price. The CubeCart_option_matrix table holds the stock level and product code for the options. However, the pricing for these options is in the table CubeCart_option_assign. There is no product_code (for the option) in this table. I also cannot find an option level relationship in the CubeCart_option_matrix table to relate the table to. Does anyone know how the relationship in the CubeCart_option_assign is defined to the option level product code? I know it is related as I have observed how the data updates when you change something in the system so I know the relationship is there. Thanks for any assistance.