CSV Import for Manual SKU Creation in NetSuite
CSV import allows manual creation of SKUs in NetSuite, crucial for handling credits, fees, and inventory management efficiently.
CSV import is a valuable tool for creating Stock Keeping Units (SKUs) in NetSuite, especially when automated processes are not utilized. This article outlines how to effectively generate SKUs using CSV import by providing structured guidelines and best practices.
Why Use CSV Import for SKUs?
Using CSV import can streamline the process of creating SKUs needed for various charges and reimbursements that arise from Amazon sales. This method is essential when users choose not to employ automatic SKU creation, which might leave some SKUs uncreated.
Key Points for CSV Import
When creating SKUs via CSV import, the following points are crucial:
- Creation of Other Charge Items: Each fee or credit detailed in the SKUs should be created as an "other charge for sale" item.
- Correct SKU Field Values: Ensure that the designated SKU fields are assigned appropriate values for consistency and accuracy.
- Subsidiary Assignment: For users operating with multiple subsidiaries, it’s vital to assign a subsidiary that corresponds to the one indicated on Amazon orders.
- Fulfillment Settings: Set the items to be not fulfillable in order to align with their intended financial roles.
- Income Accounts: Each SKU should be linked to an appropriate income account to maintain accurate financial records.
- Tax Schedules: Assign a nontaxable tax schedule to the items to comply with accounting practices.
Examples of SKUs to Create
Below is a list of SKUs that should be created as "other charge for sale" items. Ensure the Can be Fulfilled box remains unchecked and that each item is marked as nontaxable:
| SKU Name | Description |
|---|---|
| A2ZGuaranteeRecovery | Recovery fee for A2Z Guarantee claims |
| Adjustment | General adjustments made to transactions |
| Amazon Shipping Charges | Charges incurred from shipping via Amazon |
| ChargeBackRecovery | Recovery from chargeback fees |
| FBA Inventory Storage Fee | Fees related to inventory stored at FBA |
| Return Adjustment | Adjustments for returned items |
| Shipping | General shipping costs incurred |
| Subscription Fee | Fees for on-going subscriptions |
| Tax | Applicable taxes on various transactions |
Note: When naming SKUs, avoid including trailing spaces to prevent import errors.
Conclusion
Using the CSV import method for creating SKUs allows for flexibility and control in managing the various fees and service charges involved in Amazon transactions. By following the guidelines above, administrators can ensure the accurate and efficient handling of these elements within NetSuite.
Source: This article is based on Oracle's official NetSuite documentation.
Key Takeaways
- CSV import facilitates manual SKU creation for Amazon-related transactions.
- Proper configuration of subsidiary and income accounts is essential.
- Items should be classified as other charge for sale and not be fulfillable.
- Specific SKU names must be adhered to, avoiding trailing spaces.
Frequently Asked Questions (4)
Do I need to assign a subsidiary when creating SKUs via CSV import?
Should the SKUs created via CSV import be marked as fulfillable?
How should income accounts be configured when using CSV import for SKUs?
What is the important note regarding the naming of SKUs when using CSV import?
Was this article helpful?
