CCS Point of Sale
You are here: start » office » inventory » excel_import
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
office:inventory:excel_import [2013/11/20 01:52] markphillips2 |
office:inventory:excel_import [2018/12/23 12:11] (current) |
||
|---|---|---|---|
| Line 103: | Line 103: | ||
| 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:\\ | 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:\\ | ||
| - | 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.\\ | + | 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:\\ | ||
| <note tip>Select ProductName,BarcodeID,Class\\ | <note tip>Select ProductName,BarcodeID,Class\\ | ||
Trace:
