Create CSV
Several times a month, Rebel Auction sends us product listings for their auctions. They usually send them as .docx files, which isn't a greate structured data format. So we want to turn those into a CSV.
- Open DOCX in either Word of Google Docs
- Copy all data into a spreadsheet
- Everything should be in a single column
- We need to define "section headers" for the data
- The first row is a section header
- Any row with a blank space above it is a section header, you'll just want to add a blank row above each desired section header
- Look over everything, occasionally the data gets pasted in incorrectly. Also sometimes a bunch of empty rows get included.
- Excel Blank Rows: https://www.excel-easy.com/examples/delete-blank-rows.html
- Google Sheets Blank Rows: https://spreadsheetpoint.com/delete-empty-rows-google-sheets/
- Save or Export as CSV
- If in Word, use CSV UTF-8 (Comma dilimited) (*.csv)
- Google, just Export as CSV
In the end, should end up with something like this:
Tractors
"Item 1, Details"
"Item 2, Details"
Equipment & Heavy Machinery
"Item 3, Details"
"Item 4, Details"
"Item 5, Details"Upload CSV
The first thing to do is to determine the Entry ID for the auction the listing needs to be attached to.
- Go to http://rebelauction.net/
- On the homepage under Upcoming Events, click the desired auction based on the date given in the ticket. Note the title and the url title.
- In '/system', view the edit entries for the Equipment Listings channel - http://rebelauction.net/system/index.php?/cp/content_edit&channel_id=5
- The entry you're looking for will have the same title as the auction and be 'Open'.
- Click into the entry and confirm the date and URL title.
- Note the Entry ID, either in the URL of the edit page or the ID column of the listing page
Now that you have the Entry ID, time to upload the CSV
- In Addons -> Modules, open Inventory Upload Utility - http://rebelauction.net/system/index.php?/cp/addons_modules/show_module_cp&module=inventory_upload
- Select the CSV to upload
- Select the correct entry from the Select Entry list
- Delete Old Items should only be No if you need add additional items to a product listing
- Ignore First Row should be Yes. This was used in an old version that had multiple columns to allow for column headers.
- Click 'Upload & Execute'
- In the report screen, compare the Total Products to the number of rows in the CSV. The Total Products should be slightly less that the number of rows. Any major descrepencies mean something went terribly wrong.
- Check the output on the front-end and confirm everything is displaying correctly. Check for any issues such as missing header labels. Minor fixes can be fixed using the entry form, major issues should be fixed in the CSV and re-uploaded.
Respond to the Ticket
Time to respond to the ticket.
- Tag the ticket with 'Rebel Auction'
- Set the type of the ticket to 'Content Request'
- Remove the default response. Response should be something along the line of: "Brad, We have added the product listing to the auction. Let us know if you need anything else!"
- Click 'Send and Set As Resolved'
- They will not respond unless there is an issue.
You're done!