CCS Point of Sale

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
office:inventory:excel_import [2013/11/20 01:50]
markphillips2
office:inventory:excel_import [2018/12/23 12:11] (current)
Line 93: Line 93:
  
 ===== Best Practices ===== ===== Best Practices =====
-==== Barcodes====+=== Barcodes===
 All items imported should have a barcode, this can be a self generated sequential number. To create uniqueness, join two fields together, one number and one set of letters unique to the spreadsheet.\\ All items imported should have a barcode, this can be a self generated sequential number. To create uniqueness, join two fields together, one number and one set of letters unique to the spreadsheet.\\
  
Line 102: Line 102:
 == Validation of Import == == Validation of Import ==
  
-If you want to validate the import, there are two things to watch out for. The quantity of items you are importing ​and then you can import a column into the sheet that has a sequential ​entry for each row. This way you can view your import sorted by this number. You will want to use a field such as class, subclass, or style or another field that is not used by your import.\\+If you want to validate the import, there are two things to watch out for. You want to validate the total items imported, ​and the sequential results of them. The second part is done this way:\\ 
 +Setup one column with a sequential ​number. This way you can view your import sorted by this number. You will want to use a field such as class, subclass, or style or another field that is not used by your import.\\
 You can then preview the sort window using the Pivot Reporting under Office - Reporting - Pivot Reporting. Under the Advanced Tab, use a SQL statement like this one:\\ You can then preview the sort window using the Pivot Reporting under Office - Reporting - Pivot Reporting. Under the Advanced Tab, use a SQL statement like this one:\\
-Select ProductName,​BarcodeID,​Class\\+<note tip>Select ProductName,​BarcodeID,​Class\\
 FROM tblProducts\\ FROM tblProducts\\
-ORDER BY CAST(CLASS AS INT) \\+ORDER BY CAST(CLASS AS INT) \\</​note>​
 This statement uses the class field as the sequential number and sorts by this number. You can use the results of the statement to verify the import. ​ This statement uses the class field as the sequential number and sorts by this number. You can use the results of the statement to verify the import. ​
  

Navigation

^From the Ground Up!| |[[Getting Started:]]| |[[Installation Guide:]]| |[[Pre Installation:]]| |[[Install CCS:]]| |[[Install New Database:]]| ^Guides| |[[Guides:]]| |[[FAQ:]]| |[[Trouble Shooting:]]| ^Credit Card Setup| |[[Data Cap Epay:]]| ^CCS Administration| |[[ Office:Office - General Management]]| ^CCS Terminal| |[[Office:Terminal]]| ^Hand Held Setup| |[[Hand Held:|Tablet]]| ^Kitchen Display| |[[KDS Software Setup:]]|