Manually Creating Amazon Settlement SKUs in NetSuite Connector

Important:

If you have ran the automatic creation of SKUs previously, use the manual creation process only for the SKUs that were not created automatically. You may get errors if you add an SKU that already exists in NetSuite.

NetSuite Connector represents fees and credits that Amazon reports through the settlement report as other charge for sale SKUs in cash sales and cash refunds. Therefore, if you do not use the automatic SKU creation process, you may have to create many SKUs in NetSuite.

If you do not use the automated SKU creation process, you can use one of the following options:

• CSV import

• Create individual SKUs

Using CSV Import

For creating SKUs using CSV import, note the following:

• Create an other charge for sale item for each fee or credit name listed in the section Creating Individual SKUs.

• Assign the correct value to your designated SKU fields.

• If you are using multiple subsidiaries, assign a subsidiary to the item that matches the subsidiary on your Amazon orders.

• Set the items to not be fulfillable.

• Assign an income account to the item.

• Assign a nontaxable tax schedule to the item.

Creating Individual SKUs

Create the following SKUs as other charge for sale items. Make sure that the Can be Fulfilled box is not checked and the items are set as nontaxable.

Note:

Do not add trailing spaces in the SKU names.

• A2ZGuaranteeRecovery

• Adjustment

• Amazon Capital Services

• Amazon Shipping Charges

• Amazon Shipping Reimbursement

• BalanceAdjustment

• BuyerRecharge

• ChargeBackRecovery

• COD

• COD Tax

• CODFee

• Commingling VAT

• Commission

• Commission Adjustment

• Commission IGST

• CommissionCorrection

• COMPENSATED_CLAWBACK

• Cost of Advertising

• CouponRedemptionFee

• CRETURN_WRONG_ITEM

• CS_ERROR_ITEMS

• CS_ERROR_NON_ITEMIZED

• Current Reserve Amount

• Customer Return

• Customer Service Issue

• Customs Reimbursement

• Damaged:Inbound

• Damaged:Outbound

• Damaged:Warehouse

• Discount Not Applied

• DisposalComplete

• Early Reviewer Program fee

• ExportCharge

• FBA Inventory Storage Fee

• FBA Pick & Pack Fee

• FBA transportation fee

• FBACustomerReturnPerOrderFee

• FBACustomerReturnPerUnitFee

• FBACustomerReturnWeightBasedFee

• FBAInboundDefectFee_BAGGING

• FBAInboundDefectFee_LABEL_ISSUE

• FBAInboundDefectFee_SUFFOCATION_STICKER

• FBAInboundDefectFee_TAPING

• FBAInboundTransportationFee

• FBAInboundTransportationProgramFee

• FBAPerOrderFulfillmentFee

• FBAPerUnitFulfillmentFee

• FBAWeightBasedFee

• Fee correction

• Fixed closing fee IGST

• FixedClosingFee

• FREE_REPLACEMENT_REFUND_ITEMS

• GiftWrap

• GiftwrapChargeback

• GiftWrapTax

• Grade and Resell Charge

• Goodwill

• Imaging Services Fee

• INBOUND_CARRIER_DAMAGE

• INCORRECT_FEES_ITEMS

• INCORRECT_FEES_NON_ITEMIZED

• Inventory Placement Service Fee

• Inventory Storage Overage Fee

• Item Not Received

• LightningDealFee

• LightningDealFee Special

• Lost:Inbound

• Lost:Outbound

• Lost:Warehouse

• LowValueGoods-Principal

• LowValueGoods-Shipping

• LowValueGoodsTax-Principal

• LowValueGoodsTax-Shipping

• Manual Processing Fee

• Manual Processing Fee Reimbursement

• MarketplaceFacilitatorTax-Giftwrap

• MarketplaceFacilitatorTax-Other

• MarketplaceFacilitatorTax-Principal

• MarketplaceFacilitatorTax-RestockingFee

• MarketplaceFacilitatorTax-Shipping

• MarketplaceFacilitatorVAT-Principal

• MarketplaceFacilitatorVAT-Shipping

• MiscAdjustment

• MISSING_FROM_INBOUND

• MISSING_FROM_INBOUND_CLAWBACK

• MULTICHANNEL_ORDER_LOST

• NonSubscriptionFeeAdj

• Paid Services Fee

• PAYMENT_RETRACTION_ITEMS

• POS_NOSKU

• PREPFEE_REFUND

• Previous Reserve Amount Balance

• Principal_Promotion

• Premium Experience Fee

• Premium Placement Service Fee

• RE_EVALUATION

• RefundCommission

• RemovalComplete

• REMOVAL_ORDER_DAMAGED

• REMOVAL_ORDER_LOST

• RestockingFee

• Return Adjustment

• ReturnShipping

• REVERSAL_REIMBURSEMENT

• SAFE-T reimbursement

• SalesTaxServiceFee

• Shipping

• Shipping label purchase

• Shipping label purchase for return

• Shipping Reimb.

• Shipping tax

• ShippingChargeback

• ShippingHB

• ShippingServicesRefund

• ShippingTax

• Storage Fee

• StorageRenewalBilling

• Subscription Fee

• SubscriptionFeeCorrection

• Tax

• TaxDiscount

• TCS-CGST

• TCS-IGST

• Unplanned Service Fee - Barcode label missing

• VariableClosingFee

• WarehousePrep

• WAREHOUSE_DAMAGE

• WAREHOUSE_DAMAGE_EXCEPTION

• WAREHOUSE_LOST

• WAREHOUSE_LOST_MANUAL

Related Topics

Managing the Amazon Connector in NetSuite Connector

Automatic SKU Creation For Amazon Settlement Charges

Resolving Amazon SKU Data Conflicts in NetSuite Connector

Troubleshooting Amazon Connector Issues

Amazon Connector FAQ

General Notices