Frequently Asked Questions - All FAQs

Please select your question category

Search FAQs
View all frequently asked questions
View FAQ Tags
Yes, customers are required to put in their tax ID. If they don't, we have to call them and get it.
It's our way of verifying them.
 
There is an exception to this.  If you call and they are applying for one (new business) we do not need it until they order.

We create a new sales orders for "add on's". See internal Coventry procedures.

Check the quantity on the website and make sure it is a 4 digit number such as "9999."

1. Look at the customer's address - is it in Canada? If so, the customer must go through Quanta.

2. Look at what group the customer is in.

3. Make sure that the shopping cart has the $100 needed for the minimum order. To find this out, contact the customer directly and ask.

The Coventry rep can ask for the Dropbox link, which is viewable only, and forward to the customer.

1. Search to see if lead is in the zoho database. If so don't add.

2. Add to zoho as an account
-> account owner: to Gerald C.
-> Rating: New lead
-> Fill out address info
-> Fill out any additional info (email, URL, contact name)
-> in the description put lead from CCI office.

If windows 7, make sure firewall is off and network is set to home
If windows 10, make sure network is set to private and windows feature for smb is checked
--> to get to windows features : Control panel -> programs -> turn windows features on / off -> Make sure SMB is on

Windows 10 april patch disables smb sharing.

Check the template.The correct one that shows the sales rep is called "Customer Sales Order Invoice." If it has defaulted to "The Coventry Invoice" or any other, it is probably incorrect. 

This especially tends to happen if a new company file has recently been created, or new users have been added.

Here is the process to be followed for when customer issues come up. 
 
1. Account manager or customer service person finds out an issue and creates a case in zoho. Put as much information in the detail field as possible and select the correct type of issue. Assign to the CCI user in zoho with a due date of that day. Set the urgency to normal unless something warrants a higher level. The person entering the case will send an email to issues@coventrycreations.com with the same details put in zoho. 
2. Each call or email is entered in as a task  in zoho to track where someone left off with the customer. (Needed for any staff changes or vacations). 
3. When the issue is resolved the customer service person puts in a task for the account manager to follow up on the case and close the case. That task should be scheduled 10 days out. 
4. The account manager will log the results of the follow up on the customer account notes with the case name/number.
 
You will see cases if you go into the customer account and scroll to the bottom in zoho. You can create new cases by clicking the plus sign. 
 
Note: Once the case has been created and assigned to the CCI user the account manager has handed that off to the CCI user, there is no need for the account manager to insert themself into the conversation until CCI has confirmed the issue has been resolved and a follow up task is assigned. If a significant amount of time has passed and the case has not been updated you will escalate to me for next steps.  

The immediate questions:

1) What is the name of the customer?
2) What is the email of the customer?
3) What country is the customer in?
3) What is the group the customer is in on the t40S website?
4) What is the total amount of their cart?
5) what is the case number?

 
May also need:

1) What browser they are using
2) What operating system they are running
3) When was the last time they were able to place an order.
4) What page were they on or what were they doing when this happened?
5) what Time and date did the issue happen?
6) Are you able to replicate this issue on the Type 40 prod or dev site?
 
Put all this in the zoho case and assign a task out. Cases and Tasks do not always send an email. You need to always email the person it's assigned to. 

When a customer is having a web issue, take the order over the phone.   Have them read it to you. Enter a case and record the error and the entire order and attach the account.

 

The immediate questions:

1) What is the name of the customer?
2) What is the email of the customer?
3) What country is the customer in?
3) What is the group the customer is in on the t40S website?
4) What is the total amount of their cart?
5) what is the case number?

This happens when the website does not get a proper completion message from the payment gateway. Confirm the order has been paid. Then change the status to new so it can be processed. Daily check for new missing status orders.
 
 No preventative action can be done.

 

 
 
 

1) Login as shared account on dev site (varies per site)
2) Recreate order complete with correct quantities and shipping
address. Or if customer is having other issues see if you can recreate
the error the customer is seeing.
3) Put Details of order or error into an email and send to tech staff.
4) Be ready to retest and sign off as changes are made.

How to fix:
1. have the person reporting the problem go to google.com and type in
"What's my IP"
2. log into (website backend) Joocart -> Users -> API
3. Under the API tab click IP addresses and put their IP in and save.

Token needs to be renewed. Contact Jeremy

 

Make sure the formatting is correct - no headers, and the date/time match what Hootsuite expects (at the time of this post, that was hh:mm and if seconds were added, then there was an error. 

Postal code is missing during checkout.

Detail needed to start investigation
 

1) Does the Inventory on the website match what is available in QB?

2) Does the inventory on the website match what was available in the last uploaded inventory spreadsheet on Kosh?
3) If the inventory shows out of stock on the website, run the splunk dashboard (CCI - Inventory items at zero review). What is the first date it started being out of stock?
4) Were there any network issues or server work recently?
5) Do the model numbers in QB match the model numbers in the website. 
 
Create a case in Zoho CRM and report to answers and impacted model numbers to support@type40sales.com

Here's how the website inventory process runs:

 
1) Daily Quickbooks Inventory report is run and put on Kosh.
2) Hourly process looks for a new file to upload to all external Type 40 web/database servers. 
3) On the web/database server a process runs on each server looking for a new file and replaces the matching model number inventory with Quickbooks Available inventory.  (splunk is updated at this point)
4) Files are archived on kosh and the individual external server as evidence of the transaction. 
Troubleshooting:
Log into the website 
Search for the customer 
Log into the front end of the website as the customer. 
Verify the item amount in the cart. 
 
If the cart is above $100, create a screen shot of the cart total and attach to the case in zoho with additional troubleshooting detail. Assign case to the Type 40 sales support user and send email to support@type40sales.com.
1) Can you get to any other website on the interwebs?
2) Detach from the Coventry wifi and try to get to the website from your mobile device. Can you get there?
3) Is the website coming up but shows a different error? Take a screen shot and open a ticket/case in zoho crm. Make sure to assign the case to the Type 40 sales support user and email the ticket/case number to support@type40sales.com

Change the customer group to pickup from store or use customer shipping/ups number group on joocart. 

8 weeks after getting all pre production information.

New products will be available on the vending site after all preproduction information is sent to vending management.

 

The following items need to be sent over to vending management before the process can get started:
1. Recipes
2. Model and upc codes
3. Label artwork
4. Additional supplies required (i.e. cards, bags, bottles, etc)
5. Target rollout date.
6. Prices (retail & wholesale)

 if a blog doesn't show up run the pipeline by hand 

components -> ob grabber - > click arrow by category name -> manual post

see if it published

if not published, check for "/" in front of "images" 
If it still is not on website, look at the advanced pipes for the blog category to see if "update" is turned on - change force update to "no"
then re-enebale the blogs. The force update will change it to be unpublished.   

 

http not HTTP for Google tracking links

STANDARD(URL) all in caps within blog post

STANDARD links only work for website blog posts. Use direct links for anything else (newsletters, landing page, etc)

Go into the pipe and see if they match what's on resource if there's ever a question  

Check to see if the obgrabber process has been blocked by rsfirewall.  Moving to a new server will need a new ip whitelisted.

php7.4-cli php7.4-common php7.4-curl php7.4-fpm php7.4-gd php7.4-json php7.4-mbstring php7.4-mysql php7.4-opcache php7.4-readline php7.4-sqlite3 php7.4-tidy php7.4-xml php7.4-xsl php7.4-zip

Fix: 
Next time if you get same errors , then edit components/com_opencart/system/library/db/mysqli.php
Find line number 47 and 48 then comment them as follows and save
        //if(!defined("DIR_OPENCART"))
        //$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
  1. Unpublish the new blogs. Enable one at a time to see which one is not working.
  2. See if there are any special characters in the name (anything besides texts/numbers)
  3. Whack the text in the blog  and replace it with just some test text. See if that goes through.
    1. If that works it's probably a cut and paste special character.  You'll have to put chunks in to see where the issue is.
    2. Make sure to clear the system cache on resource before each pull.

Example of a cause for error: One of the links had http:/// (extra slash)

Check for pending posts in Easyblog. It may need to be approved.

--> check to see if firewall is on
--> check to see if desktop is in the same workgroup
--> check to see if current network is set to public or work (should be set to "home" or private network for windows 10)
--> check to see if bonjour service is turned off
--> check to see if SMB service is disabled because of windows 10 security patch

 

 
 
 

Can anyone else access Kosh? Y/N
Can you see other devices on the network and/or get to the internet? Y/N
Did your password change or get a new system account? Y/N
Add a task in zoho and assign to Stacy B and send an email to issues to let folks know there is a problem. Post the answers to the questions in the email and task.

Note: make sure to add user IDs as lowercase on Kosh and the windows PC. Any mixed case userids will give you problems and not work right. 
 

1) ssh to kosh putty login as the windows user and password

2) type "su -" use password <um no... no password on the web lol>
3) type "useradd new user name"
4) type "passwd new userid"
5)type "smbpasswd -a (new userid)"
6) type "/bin/restart_wins.sh
--> check to see if the file is named correctly
--> check that the correct date is in the file name
--> check to see if there are more than 2 columns in the file after the item description. (delete the extra blank columns as needed).
  1. use the url https://whatismyipaddress.com/ and copy the IPV4 information
  2. paste the copied information into an email and send to stacyb@type40id.com and note the issue, who it is for (self/customer) and WHICH website.
    1. if for customer access, create a case in Zoho and assign to Stacy B.

Customer numbers are the phone numbers. They need to have the parentheses removed and put in as XXX-XXX-XXXX

 If the company name does not match the company name in QB it will create a new customer. The duplicate customer will have to be merged in QB and updated in the website. 

Customer notes will only get wiped out when the address is updated and the customer notes are not kept in a notes/memo area. 

1) login into the admin pages for the website.
2)Go to -> components -> joocart -> customers. 
3) Search for customer email address. 
edit customer and look at each address entry. 
4) Ensure company name is set. 
Special note for account manager address book entries where they enter customer orders. 
Ensure the company name is set and address 2 reflects the customer email address. 
1) log into faire
2) go to orders
3) click the export icon at the top of the page
4) Select new orders and leave time at all time. 
5) Save csv file with the name faire-<date>-<iteration>.csv
ex: faire-2022-02-20-1.csv
6) upload file to Kosh\flie-transfers\orders-to-be-imported

All files for quanta and faire need to be uploaded to kosh\file-transfers\orders-to-be-imported.

See faire or quanta sections in the FAQ for site specific details.

2) Click on the website prefix and continue until your get to the year /month you are looking for.
3) Open the admin pages of the website you are importing orders for. 
4) Go to components -> joocart -> orders
5) Make a list of any orders with a status of new.
6) Return to repo2.type40sales.com
7) download all txt files by right clicking on the file link and saving to a directory on your computer. (suggested directory c:\downloads)
8) open Quickbooks desk top
9) open Zed axis importer
10) On the connect tab: click quickbooks desktop and click connect
11) on the import tab, browse to the first file you downloaded and select.
12) Under text file options select "pipe".
13) Under common options make sure "has header is checked".
14) Under select mapping choose "sales order".
15) make sure auto number is checked under additional options
16) Click the import button. 
17) double check shipping address.
 
 
For any issues or errors email support@type40sales.com and attache a screen shot. 

The fix: delete product and recreate it under fulfilled by merchant. Once the item is added, click on product, go to action and change to fulfilled by Amazon. When the window appears, click on convert only.

1) Go to Quickbooks reports -> memorized reports -> type 40 reports
2) Run daily completed invoices
3) change to date to be run or it defaults to yesterday.
4) Export to excel
5) Save file to Kosh\fite-tranfers\report-uploads
save as invoice-detail-year-month-day.xlsx
Ex: invoice-detail-2022-02-08.xlsx