For information how to create attributes see the link HERE.
Sku Attributes
| ATTRIBUTE NAME | ATTRIBUTE FORMAT | PURPOSE |
| Parent Sku | Text | Association to transfer quantity from parent sku (package) to the daughter sku (each) when the daughter sku runs out of QOH. |
| Disc% | Integer | The discount applied by percentage to the sku when it is added to a purchase order (similar to vendor discount, though a controlled value per sku). |
| Duty% | Integer | The additional cost by percentage applied to the sku when it is added to a purchase order (similar to extra vendor charges, though a controlled value per sku). |
| Freight Cost | Decimal | This is Default extra cost amount applied to the sku when it is added to a purchase order. Do not use Duty% attribute and this attribute at same time. |
| Case Cost | Decimal | The list cost will calculate itself based off-of the value in this field divided by the value in the PKG Qty field (List_Cost = Case_Cost / Package_Qty). |
| Margin | Text | Calculates the Reg. Sell Price based off-of a percentage added to the Average Cost. Formula: Price = AvgLandedCost / (1 – Margin / 100) |
| Markup | Text | Calculates the Reg. Sell Price based off-of a percentage added to the Average Cost. Formula: Price = AvgLandedCost X (1 + Markup / 100) |
| Disclaimer | Text | This message will print on the receipt for the sku when processed on a transaction. |
| Kitchen Printers | Text | Enter the name of the printer driver which you want a sku to print to for a kitchen ticket. |
| Notifier | Text | Displays value as a notifier message when a SKU is added to a sale (also works as a Customer attribute). |
| Authors | Text | Enter ISBN# into Product Number box in Sku creation screen, system will fill in Description, Authors, Publisher, Summary, Notes, Price. Register Access Key from http://isbndb.com/ is required. |
| Publishers | Text | Enter ISBN# into Product Number box in Sku creation screen, system will fill in Description, Authors, Publisher, Summary, Notes, Price. Register Access Key from http://isbndb.com/ is required. |
| Sell Package | Text | Enter quantities per pack and case that will be entered as Qty to be sold at the POS. |
| Buy Back Price | Decimal | Value entered will be what sku's return value will be when "Buy Back Mode" is turned on. |
| Tag Sku | Text | Automatically add a sku to the transaction that populates the “Tag Sku” field of the original sku that is added to the transaction. |
| No Price | CheckBox | Checkbox Attribute. When the checkbox is on, the POS won’t ask what the sell price is if the sku has a regular price set to zero. |
| Label Type | Text | Enter the Default Label Type name that you want selected when you open the label generator screen from this sku. |
| Rental Prices | Text | Applied charges for Rentals by increment of blocks assigned. This will be replaced if Reservation's "Prices Level" attribute has been setup and selected. |
| Consigned Date | Date | Consignment start date, Date Attribute. This is track when this item was received for consignment. |
| Consignment Discount | Text | Build auto discount rules based on this attribute. This also shows on the Consignment report. Use this as a filter column to quickly setup special price without setting up special price for each individual Sku. |
| EBT Item | CheckBox | Item qualified for EBT payment type. In payment window, EBT payment amount cannot exceed EBT items sold total. This is to ban the purchase of alcohol and tobacco products on Electronic Benefits Transfer (EBT) cards. |
| CustomerAddressNeeded | CheckBox | Customer address needed when selling the items with this attribute on. |
| Redistribute Ship To | Text | Store aliases (delimited by ; or ,) when creating Redistribution transfer requests. Transfer between stores in same region. (limits which stores it can be transferred by) |
| NO PRICE | CheckBox | If a sku has no price and you don't want it to prompt asking you to dictate a price when you add it to the POS scree, enable this switch. |
| Membership Expiry Date | Date | Specifying a date here will be used as an indicator for the duration available for store membership and customer discounts. |
| Long Description | Text | If you want to store a longer description for your product you can store it in this attribute field. Specify data in your import file for this Attribute name. |
| Member ID | Text | Used to associate what Customer is acting as a consignee for this product. |
| Reservation Group | Select Box | Select the reservation group that you want your rental sku to be associated to. |
| Base Special Price | Decimal | Lets you apply a special price without creating special price rules. |
| [CustomerType]_Price | Decimal | Lets you apply a special price without creating special price rules that applies only to {CustomerType}. |
| Store_#_Fix_Price | Decimal | This will overwrite existing prices, special price, base price, customer type price and discount rules. Dimensional price still applies. Replace '#' with the store id for for which location this should apply to. |
| Hide On Dayend | Checkbox | Enable to hide any item's return value from appearing on the bottom of the day end report. |
Customer Attributes
| ATTRIBUTE NAME | ATTRIBUTE FORMAT | PURPOSE |
| Payment Schedule | Periodically create AR invoices for Rental Agreement(Long term rental). Value can be "Weekly", "Bi_weekly", "Semi-Monthly", or "Monthly". System will create invoices based on Payment Schedule setting and Sku Price per Unit Type(DAY WEEK MONTH). | |
| Due Days | Integer | Shows on Outstanding Rental Agreement report |
| Skip Payments | For Rental Agreement, skip 1 payment means no invoice will be created automatically until next "Payment Schedule" time reached. | |
| AR Terms (Days) | Integer | Displays on invoice a specified due date for A/R to be paid when that payment type is allotted to the transaction. |
| Integer | Used to setup a specific point association for a choice frequent buyer program. | |
| Maximum Rental QTY | Integer | Used to limit the amount of simultaneous rentals allowed for each customer (obsolete?) |
| AutoEmailInvoice | CheckBox | Email invoice after transaction done. |
| AutoPrintGiftReceipt | CheckBox | Auto-print gift receipt after transaction done. |
| Notifier | Text | Show notifier message when the customer is selected in POS. |
| Customer Since | Date | System will automatically fill date in this attribute. This is used for Label and report purposes. |
| Last Modified | Date | System will automatically fill date in this attribute. This is used for Label and report purposes. |
| Last CRM Date | Date | System will automatically fill date in this attribute. This is used for Label and report purposes. |
| Image 1 | Image | Image 1, Image 2, Image 3, Image 4 are all valid attributes. Image populated to this field will appear on the invoice below the item, up to a maximum of 4 images. |
Store Attributes
| ATTRIBUTE NAME | ATTRIBUTE FORMAT | PURPOSE |
| weekday adj | Integer | Shifts date range on weekly reports by one day per attribute value. (normally weekly reports are for Sunday to Saturday. If you enter a value of 1 this attribute shifts that period to Monday-Sunday.) |
| Brite Verify API Key | Text | If you have an account with Briteverify, you will be able to validate customer e-mails by populating the API in this attribute. |
| Google Calendar Account | Text | Enter your google e-mail address in this field. Reservations in AmberPOS will be sent to your google calendar. |
| AR Terms (Days) | Integer | Displays on invoice a specified due date for A/R to be paid when that payment type is allotted to the transaction. |
| Shopping Cart Type | Text | Always populated with "BigCommerce2Full" as part of webstore integration. |
| WebDAV Username | Text | This is the e-mail address you use to login to your Bigcommerce account. Used for Webdav login credentials. |
| WebDAV Password | Text | The password key you obtain from your Bigcommerce account to login to your Webdav. |
| WebDAV Folder | Text | Always populated with "\product_images\import" as part of webstore integration. |
| Web Store URL | Text | Enter the URL of your webstore. |
| Web Service URL | Text | Obtained from your Bigcommerce account. Used for API integration. |
| Web Service User | Text | Username of your Bigcommerce account. |
| Web Service Token | Text | Obtained from your Bigcommerce account. Used for API integration. |
| Image Path | Text | Always populated with "/product_images" as part of webstore integration. |
| Combine Stores | Text | Used to consolidate inventory levels between your webstore and another store to reflect a total QOH level to be displayed online. |
| Integer | The frequency (in seconds) that your store will update information via API to your webstore. | |
| Text | The store ID of your local store to have automatically transfer inventory to your Webstore in the occurrence of a sale online. | |
| Inventory Quantity Adjustment | Text | A quantity buffer that will be added on top of the QOH from your local store. (Example: value 10 + QOH 8 = 18 available online) |
| QOHSyncStartDate | Date | Calculates QOH Web Adjustment value for a particular item. Any orders prior to the entered date will be ignored for QOH adjustments in AmberPOS. |
| Ignore Orders Update | CheckBox | Old integration attribute (obsolete) |
| Show RP Savings | CheckBox | Allows RRP price and Sale price to be populated for your products on Bigcommerce. |
| Max Number of objects in HTTP return | Integer | Increases the length before time-out for the updating of LC database. (Default Value is 250 Set to less for less time outs.) |
| LC general resources update timeout | Integer | This value represents the time interval in minutes between LC background updates for general resources only (this value has no effect for items, customers and orders, use 30 as default). |
| MaxThread# | Integer | Max CPU Threads for Web Sync, Default is 25 |
|
HTML Invoice Note |
Text | Message in text field will appear on full-size invoice printed from AmberPOS as an additional note above the "ship to" Address. |
| Order D/L Days | Integer |
Downloads BigCommerce orders that are X amount of days ago days during a LC Full Update on orders. Has been deprecated, does not work anymore. |
| QOH To Warranty | CheckBox | While check this attribute enables populating data into the "Warranty Information" field on BigCommerce. |
| QOH To Warranty Store IDs | Text | Populate the store ID values that you want to display item quantities for on Bigcommerce. Data should be formatted comma delmited (eg. "1,2,3" which means it will show QOH for Store ID 1, 2 and 3 on BigCommerce). |
| AR Pay Instore Relevant Name | Text | Input the name of the payment type issued online that you want to import into AmberPOS as Accounts Receivable. |
| SalePriceToZero | Checkbox | Sets Sale Price on BC to Zero |
| VariationPriceIsItemPrice | Checkbox | Uploads the Item main price into the variation price of an item on Big Commerce. |
Employee Attributes
| ATTRIBUTE NAME | ATTRIBUTE FORMAT | PURPOSE |
| CustomerTypeLock | Text | When creating or modifying customers info, clerk cannot select "Customer Type" on this list. Eg. This will disable certain clerks to select themselves to VIP to get VIP discount. |
Userful Articles
Importing Images and Attributes with Excel
Article written with AmberPOS version 4.15.03.27
0 Comments