Static Customer Pricing File

When prices vary by customer but do not need to be calculated dynamically, import them with Magento Admin under System > Import.
The import file must contain these columns:

• SKU: product SKU.
• website: website code, not the website name.
• email: customer email; the customer must already exist in the store.
• price: customer-specific product price.

Choose the Green Flying Panda - Customer Product Prices entity type for the import. After import, edit a customer and open the Customer Prices tab to review or delete the assigned prices.
When Customer Prices is enabled, clear the page cache so customers can see the change. Importing and deleting customer prices is also available through the API.