CSV Import for Manual SKU Creation in NetSuite

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:

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.

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.