- Home
- Company Settings
- Integration (Import & Export Data)
- Integration with Pizza Hut
Integration with Pizza Hut
Crystal Payroll can seamlessly integration with Pizza Hut stores throughout New Zealand, which will streamline your payroll processing down to as little as five minutes a week! This is achieved by exporting a timecard from Oracle Hospitality, editing it slightly, and then importing it directly into Crystal Payroll. Before we get started though, there is a little setting up you will need to do first from Crystal Payroll's side. Once it is set up though, you can delve right into using this integration each week, and minimizing your payroll processing time.
Setting Up
Head over to “Company Settings”, “Import/Export”. Under “Data Import Settings”, select "Pizza Hut" from the dropdown menu, and then select "Save"
Since Oracle Hospitality exports the report required for the integration as Surname, First Name, you will need to set up Crystal Payroll to match this formatting, and remove any Staff IDs from the "Employee Settings", "Employee Details" page if relevant.
You can enable the required formatting by heading over to "Company Settings", and then "Payroll Settings". Open "Advanced Settings". Open "Other Settings". Disable "Enable employee Staff ID" if it is enabled, and then enable "Switch to use surname, first name as employee's full name". Select "Save".
We now need to set up the special allowance items used by Oracle Hospitality. Head over to "Process a Pay" and then "Time & Income". Select any employee that is not "Approved" from the left-hand side and then select "Allowance" under "More Income & Deductions".
Select "Set Up Allowance Items" on the right-hand side of the menu, and then select "more..." on the right-hand side of the menu. Select "Add". Set the "Description" as "Sales". Select "Save". Select "Add" again, and then enter "Tips" as the "Description". Select "Save". Select "Add" one more time, set the "Description" as "Adj" and then select "Save".
Importing
Importing from Pizza Hut is relatively easy, but it does require a few quick steps. Firstly, you need to export the "TimeCardEmpDetail" file from Oracle Hospitality as an Excel spreadsheet. It must be exported as an Excel spreadsheet. Ensure you have the right file.
Once you have the file downloaded, open the file in Excel.
Delete rows "1" down to "6".
Hold "Ctrl" on the bottom left-hand side of your keyboard and then select "F" on your keyboard. Select "Find and Replace". Enter a comma (",") into "Find what:" and leave "Replace with" blank. Select "Replace All".
This will remove all commas from the excel spreadsheet. It should look similar to the below spreadsheet.
Now all we need to do is select "File" in the top left-hand corner, and then "Save As" and then save the file as a "CSV (Comma delimited) (*.csv)" file.
We are now good to import the file you saved. Head over to "Process a Pay" and then "Time & Income" in Crystal Payroll. Select an employee from the left-hand side and then select "Data Import" on the right-hand side of the page. Select "Browse". Select the file you saved. Select "Yes".
