Search found 11 matches

by mporreca
Wed Jun 07, 2023 12:25 pm
Forum: Database Help and Discussion
Topic: Extracting Toppings and Prices from database
Replies: 3
Views: 2291

Re: Extracting Toppings and Prices from database

Thanks, Scott. I didn't explain this very well. I'm not looking to update the topping charge in the database, only to extract all of the prices, put them in a spreadsheet, then use this to calculate a new price for them, which I'll use to them update another external system (Slice). Because they hav...
by mporreca
Tue Jun 06, 2023 10:04 am
Forum: Database Help and Discussion
Topic: Extracting Toppings and Prices from database
Replies: 3
Views: 2291

Extracting Toppings and Prices from database

Is it possible to extract the item toppings and prices for each item in the database? As we work on pricing updates, we'd ideally like to extract both the item price, and the toppings/topping prices for each item from the database using the \POSPZDBQT tool, import the CSV into an excel spreadsheet, ...
by mporreca
Fri Mar 31, 2023 11:01 am
Forum: CS Version Discussion
Topic: Bulk update of customer data
Replies: 5
Views: 6078

Re: Bulk update of customer data

Thanks, Scott. I was able to do this, and get the customer zip codes cleaned up. The customer list now looks good, but when I did the import, I seem to have lost the relationship between the customers and their order history. When I run a customer report for some customers, I don't see their histori...
by mporreca
Tue Mar 21, 2023 9:35 am
Forum: CS Version Discussion
Topic: Bulk update of customer data
Replies: 5
Views: 6078

Re: Bulk update of customer data

I tried this, and was able to get the data imported, but it looks like it didn't match the fields up correctly. When I did this: -I backed up the database -I exported all customers to a CSV file -I edited the CSV file with Excel, sorted it by zip code, and cleared out the junk in the zip code field ...
by mporreca
Mon Mar 20, 2023 11:43 am
Forum: CS Version Discussion
Topic: Bulk update of customer data
Replies: 5
Views: 6078

Bulk update of customer data

I'm trying to clean up some of the data left by the prior owner, who used the postal code field in the customer table for notes rather than actual zip codes, which the PAX terminals don't like. I'm able to export the data to a CSV file with the data export tool, and can clean up the zip codes in the...
by mporreca
Mon Feb 13, 2023 1:18 pm
Forum: CS Version Discussion
Topic: Record Deposit information?
Replies: 2
Views: 1714

Re: Record Deposit information?

Perfect! Thank you!
by mporreca
Mon Feb 13, 2023 7:11 am
Forum: CS Version Discussion
Topic: Record Deposit information?
Replies: 2
Views: 1714

Record Deposit information?

I went through all of the menu and screen options that I could see, but was unable to find a place where we can record a cash deposit into the safe, such as a mid-day or end-of-day drop from cash drawer, which would then show up on the deposit report when it's run. Did I miss it? If so, can you poin...
by mporreca
Wed Dec 14, 2022 10:17 am
Forum: CS Version Discussion v6 & v7
Topic: Printer on 3rd Workstation
Replies: 2
Views: 5475

Re: Printer on 3rd Workstation

Thanks, Scott. Yes, I did install that driver, to no avail. I'll see if I can track down who originally set up the system here, and see if they can add the printer for me.
by mporreca
Mon Dec 12, 2022 2:11 pm
Forum: CS Version Discussion v6 & v7
Topic: Printer on 3rd Workstation
Replies: 2
Views: 5475

Printer on 3rd Workstation

I'm running POS v6.92, and have 2 OS terminals running, with an EPSON TM-U220 Receipt printer, and everything is working fine with these two terminals. With your recommendation, I set up a 3rd POS workstation for the drivers, which is also working well. I'd like to be able to use this terminal to en...
by mporreca
Tue Nov 15, 2022 10:27 am
Forum: CS Version Discussion v6 & v7
Topic: Install new CS client for version 6.91
Replies: 2
Views: 1760

Re: Install new CS client for version 6.91

Thanks, Scott. It's amazing how smoothly this goes when you use the right version. :-)

This is installed and working well. Thank you.
by mporreca
Sun Nov 13, 2022 8:52 am
Forum: CS Version Discussion v6 & v7
Topic: Install new CS client for version 6.91
Replies: 2
Views: 1760

Install new CS client for version 6.91

I just purchased a store running POS Pizza V6.91. It is running the Client Server version, and has the server plus one client installed. I would like to install the driver console on a new workstation at this point, then once that's in place and the team is comfortable with that, upgrade to the late...