This information is taken from your shopping cart credit file and shows all cart credit activity for the day. To generate this file during End of Day, Shopping Cart Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one cart credit must be received or edited at the store.
The following table explains the naming conventions of the Shopping Cart Credit Information data share file: 1[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| 1 | This character denotes that the file contains Shopping Cart Credit information. | ||||||||||||||||||||||||||||||||
| m | This character denotes the month. The characters range from a to l and are as follows:
|
||||||||||||||||||||||||||||||||
| d | This character denotes the day. The characters range from a to z and 1 to 5 and are as follows:
|
The following is an example of a cart credit record in comma-delimited format, where the information in each field in this POS system record is separated by a comma.
“06/04/2021″,”AZON5327150423966397001H6DL00000000000000000000000″,”H6-DL”,”Duralast Battery”,””,””,””,””,”AZON”,1,”0491TRACY”,-18,18,””,”0423966397″,”05/31/2021″,22,0,0,””,””,””,”06/04/2021″,10,42,47,”06/04/2021″,10,42,47,1,”AZON5327150423966397001H6DL00000000000000000000000″,”H6DL”,0,-1,101,
We have numbered the fields in the following record in order to explain them more clearly to you. Each bolded number indicates one field.
| Note: | Some of the fields contained in this file are for internal system processing only and may not be useful to you. |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| “06/04/2021” | “AZON5327150423966397001H6DL00000000000000000000000” | “H6-DL” | “Duralast Battery” | “” | “” | “” | “” | “AZON” | 1 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| “0491TRACY” | -18 | 18 | “” | “0423966397” | “05/31/2021” | 22 | 0 | 0 | “” |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| “” | “” | “06/04/2021” | 10 | 42 | 47 | “06/04/2021” | 10 | 42 | 47 |
| 31 | 32 | 33 | 34 | 35 | 36 |
| 1 | “AZON5327150423966397001H6DL00000000000000000000000” | “H6DL” | 0 | -1 | 101 |
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | File Creation Date | The system date when the export was created. | System Date | ##/##/#### | X | “06/04/2021” | 15.26 |
| 2 | Unique ID | The unique identifier for the cart credit record. This is supplied by the publisher of the shopping cart event or generated randomly when Total Quantity is greater than one. | cartcred.uid | X(128) | X | “AZON5327150423966397001H6DL00000000000000000000000” | 15.26 |
| 3 | Vendor Part | The part identifier provided by the vendor for the credit. | cartcred.vendor_part | X(20) | X | “H6-DL” | 15.26 |
| 4 | Description | The description of the credit. | cartcred.desc | X(25) | X | “Duralast Battery” | 15.26 |
| 5 | Extended Description 2 | Credit description line 2. | cartcred.desc2 | X(40) | X | “” | 15.26 |
| 6 | Extended Description 3 | Credit description line 3. | cartcred.desc3 | X(40) | X | “” | 15.26 |
| 7 | Extended Description 4 | Credit description line 4. | cartcred.desc4 | X(40) | X | “” | 15.26 |
| 8 | Extended Description 5 | Credit description line 5. | cartcred.desc5 | X(40) | X | “” | 15.26 |
| 9 | Vendor | The ID of the vendor the credit came from. | cartcred.vendor | X(10) | X | “AZON” | 15.26 |
| 10 | Quantity | This will always be 1. | cartcred.qty | #(2) | 1 | 15.26 | |
| 11 | Order | The order designation for the credit. | cartcred.order | X(13) | X | “0491TRACY” | 15.26 |
| 12 | Cost | The value of the credit, expressed as a negative number. | cartcred.cost | #(6).#(2) | -18 | 15.26 | |
| 13 | Original Cost | The actual value passed from the publisher. | cartcred.original_cost | #(6).#(2) | 18 | 15.26 | |
| 14 | Status | The status of the credit:
(blank) Available Applied Other |
cartcred.status | X(8) | X | “” | 15.26 |
| 15 | Reference | The invoice or purchase order number provided by the vendor for the credit. | cartcred.reference | X(20) | X | “0423966397” | 15.26 |
| 16 | Order Date | The date of the order that the credit is on. | cartcred.order_date | ##/##/#### | X | “05/31/2021” | 15.26 |
| 17 | Order Hour | The hour of the order that the credit is on. | cartcred.order_hh | #(2) | 22 | 15.26 | |
| 18 | Order Minute | The minute of the order that the credit is on. | cartcred.order_mm | #(2) | 0 | 15.26 | |
| 19 | Order Second | The second of the order that the credit is on. | cartcred.order_mm | #(2) | 0 | 15.26 | |
| 20 | Cart Item UID | The unique identifier of the cart item to which the credit is applied. | cartcred.cart_uid | X(128) | X | “” | 15.26 |
| 21 | Status Comment | The commented entered when the credit’s status is changed. | cartcred.status_comment | X(40) | X | “” | 15.26 |
| 22 | Last Modified Employee | The ID of the employee who last changed this credit. | cartcred.last_mod_empl | X(10) | X | “” | 15.26 |
| 23 | Last Modified Date | The date of the last change to this credit. | cartcred.last_mod_date | ##/##/#### | X | “06/04/2021” | 15.26 |
| 24 | Last Modified Hour | The hour (1-24) of the last change to this credit. | cartcred.last_mod_hh | #(2) | 10 | 15.26 | |
| 25 | Last Modified Minute | The minute of the last change to this credit. | cartcred.last_mod_mm | #(2) | 42 | 15.26 | |
| 26 | Last Modified Second | The second of the last change to this credit. | cartcred.last_mod_ss | #(2) | 47 | 15.26 | |
| 27 | Creation Date | The date when credit was saved at the store. | cartcred.created_at_date | ##/##/#### | X | “06/04/2021” | 15.26 |
| 28 | Creation Hour | The hour when credit was saved at the store. | cartcred.created_at_hh | #(2) | 10 | 15.26 | |
| 29 | Creation Minute | The minute when credit was saved at the store. | cartcred.created_at_mm | #(2) | 42 | 15.26 | |
| 30 | Creation Second | The second when credit was saved at the store. | cartcred.created_at_ss | #(2) | 47 | 15.26 | |
| 31 | Total Quantity | The quantity of the credit sent by the publisher, but changed to be positive. When greater than one, the credit is split into that number of credit records. | cartcred.total_qty | #(4) | 1 | 15.26 | |
| 32 | Group ID | The unique ID provided by the event publisher. All credits with the same group ID were sent as a single credit with total quantity greater than one. | cartcred.group_id | X(128) | X | “AZON5327150423966397001H6DL00000000000000000000000” | 15.26 |
| 33 | Vendor Part Match | The vendor part of the credit without spaces, dashes, or other non-alphanumeric characters. Used to auto-apply credits to Return-status cart items. | cartcred.vend_part_match | X(20) | X | “H6DL” | 15.26 |
| 34 | Applied Value | The sum of the expected credit values of all the cart items to which the credit is applied. | cartcred.applied_value | #(4).#(2) | 0 | 15.26 | |
| 35 | Original Total Quantity | The actual quantity of the credit sent by the publisher. | cartcred.orig_total_qty | #(4) | -1 | 15.26 | |
| 36 | Store Number | Store number that generated the cart credit activity. | inf0.store_nbr | #(5) | X | “101” | 15.28 |
* The Output Format column uses X to represent string fields and # to represent numeric fields. E.g. X(5) represents a string up to five characters in length. #(14) represents a number up to 14 digits in length.
