Manually Creating Amazon Settlement SKUs in NetSuite Connector

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.

• 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

General Notices