Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a way you can record and export values of returns in MarketplaceAdvisor Premium?

0
Posted

Is there a way you can record and export values of returns in MarketplaceAdvisor Premium?

0

This is a way to handle returns using flags. 1. Select the order and begin to create a flag that has been refunded by clicking on the Flag button. 2. In the comments field for the flag, start (or end) the comment with a unique value (Return in this example). (Example: Return 025.00 Cheque sent on 17/08/08). 3. Run a Search for orders that have the unique value (Return) in the Flag. 4. If you want to export all results from the search, select thelink that says Export all Invoice Information. Otherwise, select only those items you want and click on the export button. 5. In the exported file you can then run the following formula on the column that has the Flag Description. =MID(D5,8,6) 6. Here D5 is the cell the flag descriptioin is in. 8 says to start at the 8th character. and 6 is to take the next 6 characters. You can now find out how much and for which orders you’ve made refunds on. Note: In referece to Step #2, the reason for placing a 0 is to keep the length of the value the same f

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123