rnewcomer
-
Posts
68 -
Joined
-
Last visited
-
Days Won
1
Posts posted by rnewcomer
-
-
1 hour ago, bsmither said:
You can have a customer be a member of more than one Group. All Groups will be shown on those customised reports/emails. So, hopefully that will not be a point of confusion to those who use this custom info.
Your plan will work provided you realize that the cheapest price wins out.
For another approach, you can set the 'price' and 'sale_price' in all records of CubeCart_pricing_group to a million dollars. (I believe) then CubeCart will find that the standard retail price of the item is less than any membership price and will offer that retail price. I think.
Yeah... I found out about the entire "cheapest price wins out" situation. I'm afraid that I'm just trying to use a "square peg" into a "round hole". So, I have deleted all customer groups. However, I still need to have some sort of quick, visual identifier as to where the customer is from... I went into Admin > Languages > *Edit* > User - Phrases specific to customers > and changed "title" to "MFG Center Number". We don't really care about Mr., Ms., etc.... So, this is a good way to tie our accounting package in.
I made a change in the content.register.php with an edit to the "title" (which now shows MFG Center Number) and added {$LANG.form.required}" required to the end of the line. I think this is going to work splendidly.
Brian, I do have three items that I'm hoping you might be able to help me with. Is it ok if I DM those to you to get your input? The items pertain to some code snippets you worked up in the past.
Thanks,
Randall
-
Ok... I think I understand.
Since I have a captive customer base from about 60 different manufacturing centers, I have assigned each to a "group" for quick identification (I use my accounting software identifier e.g. 9999-IGHQ). Further, since each group will receive the same price, is it possible to assign each to another group (0000-MINE) and set the price there and all will then get the updated pricing without too much intervention?
R
-
Correct. I am clearing the cache. I make the change, save, clear the cache.... price change is reflective in the admin dashboard > Products. Switch to Store Front, no price change.
Now with that said, for testing I changed Product I from $240.52 to $250.00. If I look in the phpMyAdmin, under CubeCart_pricing_group, I see 59 lines of the $240.52 entry.
Thanks for any help,
Randall
-
Well, I thought I had this taken care of in v6.1.12, but it has come back to me in v6.2.0.
I initially checked the "rights" of the folders and they are consistent with the v6.1.2. Perplexed. If I log into "admin", go to the product and make the change in the price, save and back out (clearing cache), the price is not reflective in the store front. I tried deleting the product and re-entering, that results in the price being $0.00. They only way I have found to change the pricing is to export the entire catalog, make the change to the singular product, then import the entire catalog overwriting all products. That's not practical.
Any thoughts...
R
-
15 minutes ago, bsmither said:
In admin, Store Settings, Features tab, Misc. section, "Order status for admin email notifications" can be set to Pending.
Perfect. Thanks once again, Brian. I looked in there, but most have overlooked "pending".
R
-
Really like v6.2.0. It's been a journey getting it working, but orders are coming in.
Latest issue is the order notification email is not sending until the order is moved to processing. How would I change that so the email is sent once the order is received into the system? I am using Brian Smither's Dropship Products plugin to notify manufacturer/departments that they have products ordered. This plugin runs when the order is moved from "pending" to "processing" and is working correctly.... It's the initial email that an order has arrived that is not delivering as soon as the check out is completed. Right now we need to check the Dashboard > Orders to see if any orders have been received.
Thoughts?
As always, thank you very much for any assistance.
Randall
-
Brian,
Yeah... I did the proverbial "knee jerk". Took a breath, searched around a little more and found a response from Al (below). Found the 'custom_oid' in the order_summary table with phpMyAdmin.... dropped it. Al states it was a bug hungover from the beta. I have since made two orders (one on network and one off) with a new test customer and have been successful so far.
Thanks for all of the help.
-
Well, I seem to have spoken too soon. I found it odd that I have not received any orders today, so I logged in as a customer and made an order. After checking out, I hoped to see the order submitted page, but I'm presented with a "404 - Page not found" page. The order is no there.
I checked the Error Log, I have a singular error in there that appears to be the order (see attached). The very last line shows an entry that reads.... "Duplicate entry ' ' for key 'custom_oid'. Not for sure what this is and am hoping someone can direct me in the right direction.
I have no idea where to begin. Thanks for any help.
Randall
-
So, here is the update...
After I had an "up and running" 6.1.15 --- I processed a couple of orders and everything was fine, including the search feature. I got a good VM export, and then upgraded to 6.2.0. As of this entry, everything is running smoothly. Not sure what the issue was, but.... there ya go.
Thanks fro the help,
Randall
-
Here's an update....
I'm running on as a virtual machine, so as soon as I get the OS up and running with SSH configured and IP address set static, I export the VM prior to stepping through the install of CC. When doing the fresh install of 6.2.0, as soon as I access the store, I get the seo.class.php errors of Duplicate entry. Accessing the test product resulted in the Duplicate entry for a number of documents.
Since I have an export of the VM to the bare bones OS, I scrapped what I was doing and started over installing 6.1.15. As of an hour ago... no errors and everything seems to be working fine.
I did nothing different in the installation steps. Kinda gun shy to upgrade to 6.2.0 now.
32 minutes ago, bsmither said:It's probably a bug in the admin-only ability to clear the cache after an insert.
Please clear the cache.
If you wish, you can log a bug report.
I will if you don't.
Brian,
Just saw your reply as if posted mine above. I tried the clear the cache to no avail. Look at my last post, maybe there is a bug. I don't know how to report it.
Randall
-
It is odd... but, here's what's even stranger.... as soon as I created the new store, these were in the error log.
I just don't know what to do from here.
-
Good Afternoon,
Doing a fresh install of 6.2. Get past the installer and the admin page and store front loads. However, If i do a search for the test product, or select the test product from the main store front page, I get a 404 -Page not found displayed and the following error in the error log (one line only):
Today, 15:41 File: [seo.class.php] Line: [659] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`,`custom`) VALUES ('login','','login','0');" - Duplicate entry 'login' for key 'PRIMARY'
The entire error log is attached.
I have searched the forum, and have found some items that are similar, but not quite the same. Thanks for any insight on how I may correct.
R
-
On 4/27/2018 at 6:09 AM, havenswift-hosting said:
If you just want customer records and there are no orders then export via phpMyAdmin from old database and import into new database
Ian
Perfect. I forgot all about phpmyadmin. Works like a camp.
Thank you.
R
-
So, I have had really good luck with v6 up to this point. The original "store" is still in production, but I have had other "fingers" get involved trying to help. This has broken the ability to update, change product pricing, etc. So, learning from my mistakes, I have built a new server and installed the latest v6.2.0. Love it. Went together very well.
My issue is I do not want to "restore" the new store from the old store BU because I do not want to inherit issues from the old store. I have moved all of the images over, was able to get a good export of products and imported them into the new server. I'm installing and configuring the plugins as we go.
Getting to the point..... is there a way to import my customer list? I only have 79, but there is a bit of data with each. I do have a good export of the customer list.
Any help would be appreciated. Thanks...
R
-
16 minutes ago, bsmither said:
into CubeCart's /files/ directory.
This is what I needed. The "rights" were not correct on this folder. Thanks again for pointing me in the right direction.
R
-
Ok, I'm assuming this is a rights issue. An admin was assigning a new user to the server and set group, owner and permissions recursively. Every file and folder is now 0755. I have been "putting out fires" as they pop up, but am unsure what the rights for each file and folder should be.
Latest example is when I am in the Admin Dashboard and chose an order, if I click the printer icon, I receive a red bar error that reads, "It has not been possible to generate the printable file." Again, I'm assuming this is related to rights, just not sure which file and what right to assign to it. Error log is empty.
Thanks in advance for any direction.
R
-
On 3/14/2018 at 9:41 PM, bsmither said:
On the receipt that the customer can print, $LANG.common.comments is a passive label and is associated with, among other things, CubeCart_order_summary 'customer_comments' column. This is what the customer has already said to you about this order. If you want the value of this column in an email, use $DATA.customer_comments or $DROPSHIP_DATA.customer_comments.
Brian, this is what I was looking for. I was able to change the "tags" I just need this little bit you responded with to place in the email templates.
Thanks again for your invaluable assistance. I have another issue that you have dealt with in the past, but I will begin a new thread for that.
Thanks again,
R
-
Yeah... I was able to change the labels. That was easy enough. I had just hoped that the field itself would follow along with the email. I’m assuming a “hook” / field would need to added to those email templates
The “your_comment” and “comments” appear to be either the same field or linked some how. Since I have edited the “label” to include “PO#”, it would be beneficial if I could get that field (not necessarily the label) to show on the order notification email and your plugin, dropship email.
I hope that makes sense.
R
-
I have edited two phrases:
-
Settings\Language\English (UK)\
-
Basket - Phrases displayed in the basket pages
- your_comments
-
Common - Phrases used in multiple places
- comments
-
Basket - Phrases displayed in the basket pages
How do I get these field (they appear to be the same) to follow along in the order process? Meaning, after submission, an email is sent to the person receiving all order notifications. The phrases field your_comments and comments do not follow along. As I look at the email, it doesn't appear, nor does it appear in the "Dropship Products" email that is generated.
How do I get this comment field to follow along?
Any assistance will be greatly appreciated. Thanks,
R
-
Settings\Language\English (UK)\
-
2 hours ago, bsmither said:
So I conclude that CubeCart has chosen to use "File" as the means to keep its internal cache.
And we know that the /cubecart/cache/ folder exists - you have examined its contents.
And we know that the template rendering engine (Smarty) is able to, or has in the past (check the dates), written compiled templates to the /cubecart/cache/skin/ folder.
So, compare the folder/file permissions between the /cubecart/cache/ and /cubecart/cache/skin/ folders.
Just to be sure, CubeCart is installed in a sub-directory /cubecart/?
Fixed!!! You led me down the correct path. One of my people decided she was going to "help" me and "fixed" some permissions. All is well in the world.
Thank you so much for your assistance.
R
-
17 hours ago, bsmither said:
In admin, Store Settings, Advanced tab, enable Debugging and enter your IP address (www.whatismyip.com) in the adjacent field.
Request any CubeCart page.
There will be a large grey section at the bottom of the page.
At the very bottom, just above Page Load Time:, find this line:
Cache (Abc): Always Disabled in ACP
where Abc could be File or something else, and Always Disabled in ACP will show only when in admin and Enabled when in the storefront.
If the cache is not coming from File, then perhaps a conversation with the cache mechanism application developers is needed to determine why/if whatever cache option CubeCart is using to cache the SQL queries is not getting cleared.
Ok... After much crying and gnashing of teeth, I was able to get the price to change and be reflective of what it is supposed to be. There for a while, it would only show $0.00.
Now a new wrinkle... and this may be a permissions... On the top of the page (admin and client), it reads:
Warning: Could not change cache path (/var/www/html/cubecart/cache/) in /var/www/html/cubecart/classes/cache/file.class.php on line 258.
Here are lines 243 - 264 as they are germane to caching:
/**
* Set cache path to some where else
*
* @param string $path
*/
public function setPath($path = '') {
if (empty($path)) {
$path = CC_ROOT_DIR.'/cache'.'/';
} else {
$ds = substr($path, -1);
if ($ds != '/' && $ds != '\\') {
$path .= '/';
}
}clearstatcache(); // Clear cached results
if (is_dir($path) && file_exists($path) && is_writable($path)) {
$this->_cache_path = $path;
} else {
trigger_error('Could not change cache path ('.$path.')', E_USER_WARNING);
return false;
}return true;
}Thoughts? Thanks,
R
-
On 3/1/2018 at 7:47 PM, bsmither said:
Observe the directory contents of CubeCart's /cache/ folder. Especially the SQL files. When you Save the new prices, CubeCart should delete all SQL cache files. They will soon enough be rebuilt. CubeCart should clear the cache directory whenever an admin makes any kind of change. So, the SQL cache files should have new recent timestamps.
In admin, Store Settings, Advanced, disable caching (for the moment). Determine if that makes any difference.
Brian,
Thanks for your reply. The only '''cache" folder that I have been able to find is html/cubecart/cache. It is empty except for one folder named skin. Skin contains about 156 .php files. Is this the correct spot?
I have disabled caching for the moment as you suggested, however price still doesn't change after editing. The only way to get an updated price is to delete the product and rebuild it.
Stymied.
R
-
On 3/2/2018 at 3:12 AM, keat said:
I've found, if you have a product in a customer cart at one price.
Log in as an admin and change the price.
The price change is not reflected in the customers cart. He added it before you modified the price.
May not be the same issue but worth me mentioning.
Keat,
Thanks for your reply. However, this isn't the case here. It's odd.
R
-
Hey Brian, thanks for the questions...
- Each customer that logs in is a member of "center" that they login as... Example someone from the Dayton, OH Center is in group DAYT-2001. Each of the 60 centers have their own alpha-numeric group code.
- We aren't doing any price schedule adjustments. Each of the 60 centers will pay the same amount.
- Non-Logged-in visitors do not see pricing. You need to be a verified, registered "customer" and logged in to see pricing.
- I host internally on my own machine, we haven't made any type of caching changes.
Right now what I need to do for price changes, is delete the product and re-enter.
RLN
Price not updating
in Technical Help
Posted
Thanks... sent you an email so that I could include three text file attachments.
R