Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?


Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site

 All Forums
 Technical
 PHP (Unix / Linux / Apache) versions
 Reportin Orders/Inventoty
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic   

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/21/2020 :  06:00:19  
Hi there,

Is it possible to download a csv file that shows over any selected period of time what items/product codes were ordered? That shows the sku code, qty sold.

If there is, is it possible to use a spare field in admin, that would include the cost trade price, carton cost, shipping cost, so when the orders were downloaded on a report, I could see item code sold, qty sold, selling price it sold for on website, and these new fields, cost price of item, carton/box price, shipping cost?

If yes, this could be quite a good report to use in conjunction with Google Adwords analysis when doing a Vlookup against Google adwords product merchant data.

Jason

Vince
Administrator

39437 Posts

Posted - 11/21/2020 :  11:17:34  
Hi Jason
It's a good idea but not available I'm afraid. Sorry about that.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/21/2020 :  13:10:01  
Hi Jason, many store owners use ship station to ship orders and if you happen to use them as well, there are a ton of reports in there.
It's quite extensive.
There is even a report that will show you what to collected in shipping compared to what you actually paid.
It even highlights the color to show green or red - (less or more) so you can spot the orders/items where you lost money on shipping.

Thanks,
David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/21/2020 :  13:42:26  
Hi Both,

Is there no way to add some extra fields like I have done with the below, but that appear in the orders csv download? If i can add extra fields in the admin that I can add data to, that can appear on an export with the orders, sky, qty, amoutn etc, along with the extra data I need, I think I will achieve what I am after?

$detailpagelayout='navigation,productimage,productname,discounts,price,listprice,currency,instock,reviewstarslarge,shortdescription,options,quantity,addtocart,Custom1,productid,manufacturer,sku,dateadded,description,previousnext,searchwords,socialmedia,reviews';

$productpagelayout='productimage,productname,reviewstars, instock, listprice,price';

$detailcustomlabel1="";
$admincustomlabel1="";
$customquickupdate="pCustom1";

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/21/2020 :  14:17:10  
Hi Jason, there is no built in feature like that for order details download.

Thanks,
David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/24/2020 :  10:29:55  
David,

I have seen there is a csv download for orders and order details.

Is it not possible for me to add a new field in admin "cost", which will be where I enter the total cost (my buy price) of the item sold. Which would then appear on the orders download from admin?

Jason

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/24/2020 :  11:02:29  
Hi Jason,
quote:
Is it not possible for me to add a new field in admin "cost", which will be where I enter the total cost (my buy price) of the item sold. Which would then appear on the orders download from admin?


Sure, anything is possible with the right coding skills.
You would need to alter the core code and redo those changes whenever you update.
The nice thing about the ECT store is you (or a developer) can make these changes if you like.

Thanks,
David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/24/2020 :  11:24:36  
Dave

This is totally true, as many popular platforms would never allow custom changes like this, which makes others really poor in my opinion.

Jason

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/24/2020 :  11:48:53  
Hi Jason, here is a list of possible developers if needed - https://www.ecommercetemplates.com/developers.asp

David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/24/2020 :  12:22:26  
Hi David,

Before I approach a developer, is it possible for me to do the following.

We will not use wholesale pricing, but if I enter a figure in this text box for whole sale price, but for me this will be my overall cost for the product item,
can this appear in the "Dump Orders to CSV" or "Dump Details to CSV".

Inputting the cost data is for me quite crucial, and can really help in conjunction with data from Google to work out
profitability of advertising campaigns a lot quicker.

Jason

Edited by - Jolly-Martian on 11/24/2020 12:29:28

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/24/2020 :  14:01:08  
Hi Jason, the csv that is exported from order details is information from the tables in the database that contain order data and it's not really pulling any information from your products table of the database. So with this in mind, you would still need to have some custom coding done to get that wholesale column pulled in with the csv data export.
It's not a bad idea to repurpose the wholesale field for that, but it really doesn't get you much closer to getting the info in the order details csv.

What about accounting software? Do you use quickbooks perhaps?
There is a 3rd party tool for moving orders to quickbooks, so if your product costs were setup there, you can get your reports easily from qb.

David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/24/2020 :  15:20:05  
David,

I use Xero, that is a perfect idea, I have imported orders into Xero before with employers i have worked for, I should have thought of that myself :)

Thanks

Jason

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/24/2020 :  16:16:59  
Hi there,

When I download the inventory to csv, in the SKu column instead of displaying the GTIN number as 8436564540676 its displayed as 8.43656E+12

when i change the formatting to number it corrects and displays the number in full, but when i save to csv for upload to inventory upload,

it changes back to scientific again, any ideas?

Jason

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/24/2020 :  18:33:30  
Hi Jason,
csv files are not the same as excel files.
It's just data, columns cannot be scientific - just numbers and letters.
Have you tried to open the file with a text editor instead of excel?
Opening a csv in excel can actually cause problems sometimes.

Perhaps download notepad++ and open with that and see what the data looks like.

I have a great csv editor (Killink CSV) I purchased from White Peak software, but he quit offering it a few years ago.
I see some other websites have it now, but I don't know if it's the same, or legit.
There are other pure csv editors out there too.

I rarely use excel to manipulate csv files.

Thanks,
David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/25/2020 :  03:56:59  
David,

Thanks for the response, yes I definitely learnt the hard way last night i downloaded the inventory on the 23rd from admin, i reduced all the sell prices
by 30% and uploaded these back through the inventory upload in admin. What I didn't realise was because a lot of my descriptions have the " sympol and ' for inches e.g.
15.6" laptop or words with the apostrophe, when i saved the file back to csv after my edits, the uploaded to the database replaced " with and replaced ' with .
Where every the import changed to these character sets the descriptions all got deleted after these character sets. I didn't realise this until yesterday. I managed to open the
original csv inventory download in excel as an import from txt file, and changed the GTIN/SKU column to a txt format, made my price changes, and then saved as csv, and uploaded
which worked fine.
?
With all that in mind, what is the best way for me to edit e.g. 200 product prices to reduce by a % amount from the price, there will be periods through the year where I will want to reduce prices by a %
quickly and efficiently, the reason being is if i have e.g 200 edits to do and i start making this changes, in the meantime, google may do a price craw and see the merchant center prices are different
to my website prices, and that is only because if i do it manually reduce each one by 30% may take me 30 Mins + and i cant run a new Google Merchant center feed until I have finished my edits, so
the inventory upload is faster and more efficient, however there needs to be a quicker way to change the prices by a % of the list price without having to use csv files perhaps so the GTIN long numbers
don't keep changing.

Do these text editors allow changes to columns like in excel with formulas?

Jason

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/25/2020 :  04:48:13  
The way I do this is I open the csv file in my non-excel csv editor and then copy the price column over to excel, use excel to work the pricing magic, since it's great for that, then I copy the new column from excel and replace the date in the non-excel editor.

One thing to keep in mind though, is you can remove the description column from your csv file there in excel if you are not making changes to that column.
Any missing columns from the csv, and that data will be skipped over and remain when uploading.
So (if you must use excel) you could download the csv, open in excel, remove all columns except the product ID and pricing, edit your pricing and upload.


Thanks,
David

Jolly-Martian
Advanced Member

United Kingdom
169 Posts

Posted - 11/25/2020 :  04:52:31  
David,

This response is priceless to me "Any missing columns from the csv, and that data will be skipped over and remain when uploading." Thanks

I didnt know this, I was wondering this last night, this makes sense that the import will ignore blank columns.

So to clarify, if I download the product inventory to csv, the only things likely to be affected by importing csv back is description and sku/gtin, therefore if I am only
updating the list price and price, do I delete all other colomns with their headers, or do i remove the data from each of the coloumns I do not want changes made and
leaver the headers?

Jason

dbdave
ECT Moderator

USA
8802 Posts

Posted - 11/25/2020 :  05:44:02  
Remove the column entirely - Header and all.

Thanks,
David
   Topic   
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2020 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000