-- Bulk import of existing canned responses from ProvideSupport (category: Company)
INSERT INTO canned_responses (operator_id, category, shortcut, response_text) VALUES
  (NULL, 'Company', 'How can I assist you today?', 'How can I assist you today?'),
  (NULL, 'Company', 'Let me check that for you', 'Let me check that for you, just one moment.'),
  (NULL, 'Company', 'Just one moment please.', 'Just one moment please...'),
  (NULL, 'Company', 'What is your order number?', 'What is your order number?'),
  (NULL, 'Company', 'Use Quote Wizard', 'goto: https://w2g.us  where you can get a free quote and schedule online 24/7.'),
  (NULL, 'Company', 'Lic or VIN', 'Your vehicle could have options that would change the glass needed. It would be helpful if you could supply us with your VIN or License Plate & State so that we can determine the correct glass.'),
  (NULL, 'Company', 'Thank you for contacting us today.', 'Thank you for contacting us today.'),
  (NULL, 'Company', 'Sorry no service', 'I am sorry we do not currently have service in your area.'),
  (NULL, 'Company', 'Part Not Available', 'Sorry, we do not have this part in stock.'),
  (NULL, 'Company', 'No Stock locally', 'Sorry, we do not have this in our local warehouses. We do have it in XXX for pick up. (They do not ship). If this is an option please let us know.'),
  (NULL, 'Company', 'Zip', 'What is your ZIP code?'),
  (NULL, 'Company', 'Year make model', 'What is the year, make, and model of your vehicle ?'),
  (NULL, 'Company', 'Options', 'There are many options possible for your vehicle, we would need your VIN to give you an accurate quote.'),
  (NULL, 'Company', '2 door or 4 doors?', '2 door or 4 doors?'),
  (NULL, 'Company', 'Station wagon?', 'Station wagon?'),
  (NULL, 'Company', 'Standard cab or extended cab?', 'Standard cab or extended cab?'),
  (NULL, 'Company', 'Super cab?', 'Super cab?'),
  (NULL, 'Company', 'Logo?', 'Do you need the glass with a Logo? They are always more money.'),
  (NULL, 'Company', 'Status', 'goto: https://windshieldstogo.com/status.php#status'),
  (NULL, 'Company', 'Auth', 'We "authorize only" your credit card the day of the installation to verify we have the card information correct and that the funds are available. We will then capture the funds the next day after the work is completed.'),
  (NULL, 'Company', 'Installed or glass only?', 'Installed or glass only?'),
  (NULL, 'Company', 'Installed price is $ xxxxxx', 'Installed price is $ xxxxxx'),
  (NULL, 'Company', 'The next mobile service in your area is xxxxx', 'The next mobile service in your area is xxxxx'),
  (NULL, 'Company', '2nd part', 'If you need more than one part, after checkout you will have access to the Status System where you can let us know what you need and we will add it in. You are not charged at checkout. We will contact you if we have any questions.'),
  (NULL, 'Company', 'Check out "Note"', 'This is the note at check out: "You will be authorizing a few cents at this time that will not be charged. For fraud purposes, we may ask you to check your credit card account and let us know the amount you see. The full authorization will only occur after we verify availability and that no other parts are required (if there are any, we will contact you). If this is for an installation, the full amount will be authorized the morning of the installation and the funds will be captured the following day."'),
  (NULL, 'Company', 'Guarantee', 'goto: https://windshieldstogo.com/faqguar.php'),
  (NULL, 'Company', 'Calibration', 'A windshield with "Lane Departure Warning", "Forward Collision Alert", etc. may require calibration. Calibration is not needed more than 95% of the time. Our installers do not unplug the camera(s). Your vehicle\'s notification system should let you know if there is a problem. This is a service not included in our price. Not all of our installers have the equipment but if available we can quote you a price. If calibration is needed and we can not supply the service your vehicle would need to be taken to the dealer or an aftermarket calibration service (The cost for this service varies a lot).'),
  (NULL, 'Company', 'Warehouse', 'After you place the order, we put your glass on will-call at the warehouse you requested (Sometimes there are more than one in the same area) We then send the pickup details over to you including address, part number, and instructions. You are not able to pay at the warehouse, they are wholesalers and do not sell to the public and have asked that we not give out their address until we have placed an order.'),
  (NULL, 'Company', 'No installes prior to 1980', 'We do not install anything prior to 1980 because the modern installers are not trained for these more complicated installs.'),
  (NULL, 'Company', 'Shipping Overseas', 'We do not ship overseas but can ship to a "Forwarder" of your choice here in the States. You can get a price and order at https://w2g.us/wiz  You would put the address of the Forwarder in the address field. after ordering we would need you to access the Status System and supply us with the Forwarders name and the final destination. Choose to ship ($275 if this is a windshield) and it will be packaged for overseas and delivered.'),
  (NULL, 'Company', 'Is there a Phone number where I can reach you at this moment?', 'Is there a Phone number where I can reach you at this moment?');