Can I import products with custom attributes and categories simultaneously

1. CSV File Structure:
- Include columns for both categories and attributes in your CSV file.
- For categories, use a single "Categories" column.
- For attributes, use columns named "attribute:AttributeName" (e.g., "attribute:Color", "attribute:Size").

2. Category Formatting:
- Separate multiple categories with commas.
- Use ">" to indicate hierarchy (e.g., "Parent Category > Child Category").

3. Attribute Formatting:
- List attribute values in the corresponding attribute columns.
- Separate multiple values with a pipe symbol (|).

4. Import Process:
- Use WooCommerce's built-in importer or a plugin like WP All Import.
- Map the CSV columns to the appropriate WooCommerce fields during import.

5. Considerations:
- Ensure category names match existing categories or are formatted correctly for new ones.
- For global attributes, use the prefix "pa_" (e.g., "attribute:pa_color").
- Custom attributes don't need the "pa_" prefix.

6. Example CSV row:

   SKU,Name,Categories,attribute:pa_color,attribute:custom_material
   PROD001,T-Shirt,Clothing > T-Shirts,Red|Blue,Cotton
   

7. Best Practices:
- Test with a small batch of products first.
- Back up your database before large imports.
- Use a plugin like WP All Import for more advanced import options.

By structuring your CSV file correctly and using the appropriate import tool, you can successfully import products with both custom attributes and categories in a single process.