Home » Community » General Discussion » Mass Markup Tool Question
Search Search  
Show: Today's Messages    Show Polls    Message Navigator
Mass Markup Tool Question [message #34850] Thu, 22 September 2011 01:47 UTC Go to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
Hey guys!

So, say we are implement a mass markup tool. Say it's a CSV import/export. All hypothetical, of course. ;o)

Is there any reason you would want to see models that are not public on such a hypothetical CSV?

Remember, all your models x all your materials = looooong spreadsheet.

Just curious...



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #34856 is a reply to message #34850 ] Thu, 22 September 2011 02:20 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
private on spread sheet is a must. all new ring designs are private with 1 public linking the others. that way i can have each size already done. con lots of models that need updating occasionally.

also would want to see:
name
volume
dimensions
category
ect.

these are important in automatic pricing


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34857 is a reply to message #34850 ] Thu, 22 September 2011 03:15 UTC Go to previous messageGo to next message
avatar dizingof  is currently offline dizingof
Messages: 1288
Registered: October 2009
Go to my shop
Shapie Expert
I just deleted over 200 of my models... focusing my (last) efforts on the new ones.. - so no more mass updating headache...


What was selling a year ago cant compete with new designs.. and 100s of shops..
Aggregating designs backfires at your sales.









http://www.3Dizingof.com
Re: Mass Markup Tool Question [message #34861 is a reply to message #34857 ] Thu, 22 September 2011 05:29 UTC Go to previous messageGo to next message
avatar christopherlowe  is currently offline christopherlowe
Messages: 138
Registered: April 2011
Go to my shop
Senior Member
i hadn't thought about it but i would like as much information as i possibly could have in there. this could be a whole new way of setting up shop.

for instance you could also list product title, file name and description too. then those could also be changed/updated too. i would also like some sort of history on the objects as well like date uploaded. maybe #views, #likes, #sold would also be good information to include. while we are at it sale dates, amount gross and profit would be nice too.

the only thing that i could see problematic is on the size/volume portion and file name listing. but you could limit this issue by getting the importer to ignore the size/volume fields and if there is a conflict with the model name field it would ignore that too until the shop owner could come back in there and replace the file that has been lost.

i see this as a possible powerful tool that give shop owners far more creativity if implemented in the right way.

chris


please visit my blog at...
http://chrisshopofmodels.blogspot.com
Re: Mass Markup Tool Question [message #34866 is a reply to message #34850 ] Thu, 22 September 2011 10:34 UTC Go to previous messageGo to next message
avatar tebee  is currently offline tebee
Messages: 436
Registered: December 2010
Go to my shop
Senior Member
If you mean my private, stuff not viable to the general public but still orderable buy others then I would defiantly need to see that. I have items commissioned by clients, some have paid up front but some I am recovering from each one sold so I need to know the mark-up on those.

If you are talking about what only I can order, most will have no mark-up and so is less important.

But considering I'm dealing in files with just under one million vertex even I I have 1000 models any you have 100 materials we are till only talking of 100,000 points of data and most modern spreadsheets should be able to handle that.

I mean, this is what spreadsheets were made for, Handling and making sense of large chunks of related data.
Re: Mass Markup Tool Question [message #34873 is a reply to message #34850 ] Thu, 22 September 2011 13:16 UTC Go to previous messageGo to next message
avatar Youknowwho4eva  is currently offline Youknowwho4eva
Messages: 5571
Registered: September 2008
Go to my shop
Shapie Expert
I work here
Yes have them, especially if you could have them separate. At least grouped together if not two separate pages. (Sorry if I'm using inappropriate CSV language, no idea what that is Razz)


I learned a long time ago the wisest thing I can do is be on my own side, be an advocate for myself and others like me. -Maya Angelou
michael@shapeways.com Community Advocate
Re: Mass Markup Tool Question [message #34876 is a reply to message #34873 ] Thu, 22 September 2011 13:35 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
Csv coma sepeated value

One line per model. No such thing as pages


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34877 is a reply to message #34850 ] Thu, 22 September 2011 13:40 UTC Go to previous messageGo to next message
avatar Youknowwho4eva  is currently offline Youknowwho4eva
Messages: 5571
Registered: September 2008
Go to my shop
Shapie Expert
I work here
Ok, did some googleing. 2 separate files than? As long as they aren't all mixed together.


I learned a long time ago the wisest thing I can do is be on my own side, be an advocate for myself and others like me. -Maya Angelou
michael@shapeways.com Community Advocate
Re: Mass Markup Tool Question [message #34881 is a reply to message #34877 ] Thu, 22 September 2011 13:59 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
1 file would be best. Excel and all other spread sheet programs have a sort function that will let you sort in any order you want as long as the data is there to sort by.

So if you want to seperate by visible status you can. If I want to sort by volume and category I can. But only if all together.

May i request that a markup or sales price of $-1 be considered not available. Makes it so 1 field does availability and markup

[Updated on: Thu, 22 September 2011 14:01 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34890 is a reply to message #34881 ] Thu, 22 September 2011 15:49 UTC Go to previous messageGo to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
Since we need to get this out fast, we will likely stick to the bare minimum feature--meaning only using this as a means to update your markups, not add tags, descriptions, change titles, public/private. This is because the more elements we add, the more ripple effects it has for development (ex: to do error checking across all those fields, to write out the comprehensible and helpful error messages, things like that).

We will be expanding this CSV tool into a more robust shop management feature set, so bulk updates to other things (tags, shop sections) is on the agenda. But for the short term (ie next Wednesday), we are only limiting the CSV to markup edits.

Thanks,
Nancy



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #34894 is a reply to message #34890 ] Thu, 22 September 2011 16:40 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
nancy you menioned one with volume one without. we need volume both ways.

For example I would want to set the price not markup but I need the volume field to know what I can charge for each model. For example under 3cc I would set to 9.99 in WSF but over 3cc I might set to ceiling(volume*1.4+5)-0.01 which would give me a $3.50 markup and final price rounded up to $x.99

If you are not going to add visibility and other advanced features on import. Export them anyways for sorting reasons and so layout will not have to change in the future when you implement them. Even if you leave things like description blank leave a spot for it.

[Updated on: Thu, 22 September 2011 17:06 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34913 is a reply to message #34894 ] Thu, 22 September 2011 20:51 UTC Go to previous messageGo to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
Hey guys,

One thing to keep in mind is that this CSV will also be available for all shopowners. So things like adding empty columns is unfortunately not a good experience for the majority of people out there.

On the volume question, I want to make sure I understand your problem correctly. What I'm thinking right now is one spreadsheet with both the current pricing in one column, and the new pricing in another column. If you have both the current and new pricing in one spreadsheet, what more info do you need from the volume column? I thought the volume is mainly there to calculate the new pricing, but I think it would actually be easier to embed the new pricing into the spreadsheet--save you guys one extra step.

Thoughts?

Thanks!
Nancy



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #34918 is a reply to message #34913 ] Thu, 22 September 2011 21:27 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
Here is the layout I proposed a while back: http://www.shapeways.com/forum/index.php?t=getfile&id=10 015&

As you can see even with just 1 coloumn per material per price it is a pretty wide layout. Let alone doubling with current and new.

For me I would have no need for current as I would write a formula to assign the value of each model and then copy it, and paste values only back to the same location so your server does not need to deal with the formulas.

SO for example in my spread sheet L3 is the first items volume so for AA3 which is the model price in WSF I would enter

=IF($L3<=3,9.99,IF($L3<=4,11.99,IF($L3<=5,14.99,CEILING($L3*1.1+5,1))))


This would set the price of all my models to $9.99 if under 3cc, 11.99 if under 4cc, 14.99 if under 5cc, and if over 5 cc set a markup of 10%+$5 and round up to $x.99

I can then cut and paste this formula to every single model and excel will calculate my optumum sales price for me.


As for empty fields. We are inteligent people. Let us know the filed is left blank for future use. I would be saving this file on my hard drive and every time I want to make changes I would cut and paste my formla sheet over to the downloaded one. My formulas will only stay valid though if you don't move things around.

If you need to move things a year or 2 from now that is not much of a hassle. If you don't leave extra space it will either get gumbled up or you will be moving stuff often which would be a problem as I will have to rewrite the fomulas possibly resulting in typing mistakes.


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34921 is a reply to message #34918 ] Thu, 22 September 2011 22:04 UTC Go to previous messageGo to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
The other thing to consider is what are the must haves and what are the nice to haves, because we are also working on things like adding features back to product details, speeding up the website, so we need to prioritize and hit on the must have items. Thus far I have:

- model title: must have
- material: must have
- base price (old): must have
- base price (new): must have
- alternative: volume (so you can calculate the new base price)
- markup: must have AND editable
- public vs. private (but on sale)

The other things I am putting in the nice to have bucket
- categories
- tags
- shop sections (though I feel like we should have either categories, tags, or shop sections--I'm leaning towards shop sections now)
- views
- favorites
- volume
- surface area

For my shops, I don't actually use categories/tags/shop sections so much since I try to keep my shops (not the ones on this account) minimal.

Things that seem simple, ie adding number of page views to the CSV, can actually take a while to spec out and implement. What are views, should we count distinct or repeating... Google Analytics counts views differently than our internal systems, and so on. My goal is to get this out by next Wednesday, so you guys have at least Thursday and Friday to play around with the tool. That's why I want to make sure we only focus on the must haves.

The empty row columns thing.. what you are basically asking for is that we think out once and for all what is needed so you don't have to update your formulas. I can appreciate that. However, this puts me in a difficult spot because there will be changes in the future anyway (say we add a wall thickness detector or something like that), and present a fully thought out sheet makes it (1) less flexible to add new features in the future (2) less flexible to change the spreadsheet to tweak usability (3) on the whole a more complex experience (I can deal with spreadsheets and code too, but there are more smart and creative people out there who prefer simplicity) and (4) potentially delay in the roll out because there are a lot more things to plan for and think through (each data type also has distinct error cases to work through so we get good data validation).

Anyway, long post, but I want to make sure you guys know that we are having these discussions and really thinking through our decisions in depth, and also provide some transparency into our thinking along the product dev process.

Let me know if you have any more questions!
Thanks,
Nancy



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #34924 is a reply to message #34921 ] Thu, 22 September 2011 22:21 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
nancyliang wrote on Thu, 22 September 2011 22:04


The empty row columns thing.. what you are basically asking for is that we think out once and for all what is needed so you don't have to update your formulas. I can appreciate that. However, this puts me in a difficult spot because there will be changes in the future anyway (say we add a wall thickness detector or something like that), and present a fully thought out sheet makes it (1) less flexible to add new features in the future (2) less flexible to change the spreadsheet to tweak usability (3) on the whole a more complex experience (I can deal with spreadsheets and code too, but there are more smart and creative people out there who prefer simplicity) and (4) potentially delay in the roll out because there are a lot more things to plan for and think through (each data type also has distinct error cases to work through so we get good data validation).



Actually all I am asking for now is the musts. Page views, tags, ect you can fill with a NA and ignore there value on import. Think through what could reasonably be needed(which is what I did to make that layout) then leave a few blank spots that you can use up. It does not effect my formulas if you add something to a column that is unused. If you do that you may eventually outgrow the extra space you left. That is ok since it will not happen that often. At that point you tell us you are now using CSV 1.1 take note of the changes leave a few more blank space for the futere and keep on going. Having a version number as reference is also important.

As for your points:
1) You are restricted to adding new things to the blank spaces or to the end. But only until you make a version change which you should try to as seldom as possible. This is not that big of a restriction. And is a must because CSV means that people can write apps to help shop owners deal with there store inventory and apps require known layouts.

2) Yes if you put things in a bad order you are stuck. Again user apps can handle that and a little bit of pre planning should minimalize. Use my example as a starting point I spent a bit of time thinking it through.

3) The layout I proposed is not very complex. But you can always offer a simplified view also. But generally I think the bes solution is more info so apps and education can let people get the most out of it.

4) I have done a fair bit of the leg work by making a workable layout. Also you can always ignore fields and fill with NA until you are ready to use. Get the must dones first. Leave room for the wants in a place that is logical to put them.


I am admit about having a known layout that will not change often for multiple reasons.

1) Mistakes can happen with pre writen formulas when things get moved.
2) There are many smart programers here that could write really nice apps that could manipulate the csv files for shop owners in cool and new ways. For example I will write a new product inventory page that will work instead of the poorly coded one that already exists. People could upload there csv file. make changes in my app then upload the resulting csv back to shapeways. Means you can do less work as your customers can make what they need.


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34927 is a reply to message #34921 ] Thu, 22 September 2011 23:07 UTC Go to previous messageGo to next message
avatar christopherlowe  is currently offline christopherlowe
Messages: 138
Registered: April 2011
Go to my shop
Senior Member
how about a selection process...

say when you want a spreadsheet for your shop you click on a button that says - generate spreadsheet-

that takes you to a sub page with all of the options available to include in the spreadsheet. certain things are automatically be included but others are available to include.

you make your selections and then say download and the csv will download to your hard drive.

now what i would imagine in the spreadsheet is...

the rows are the objects and the columns are the information that you requested. to alleviate the growth potential issue- with the names of the on the 1st row the importer at shapeways will know that the values of what that column represents so on re- importing will rely on this information instead of arbitrary "column q represents values for whatever" this will make it so that it is usable for the casual shop as well as powerful enough for the power user. and be infinitely expandable.

one more thing i would like to request for this process. can we make it so that our shops follow the order that the spreadsheet is in.... so we could re arrange what a customer sees when they first enter into the shop.

thank you and good night.


please visit my blog at...
http://chrisshopofmodels.blogspot.com
Re: Mass Markup Tool Question [message #34929 is a reply to message #34927 ] Thu, 22 September 2011 23:58 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
For me I would prefer at the beginning of the page 2 buttons and a file box. One button to download another to upload. After that other options could be available but minimizing clicks is always a nice thing.

Name based columns is easy to implement for apps and shapeways import. Impossible for pre writen spreadsheet formulas. It is for those using Excel and that want to be able to do formula based that I am strongly encouraging a pre thought out format with room to grow. For apps you are right I could read the header and assign everything based on that.


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #34931 is a reply to message #34921 ] Fri, 23 September 2011 00:59 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
Here is my perspective..

The download file should have:
- model number: must have
- model title: must have
- material: must have
- base price (old): optional
- base price (new): optional
- volume: must have
- surface area
- markup: must have AND editable
- public vs. private
- for sale or not

Knowing how databases tend to work.. this process really should be keyed to the Model# .. I could easily have two models with the same title, and the title can change over time, where the Model# would not.

The return (upload) file could be as simple as:

- model number
- material
- markup


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #34932 is a reply to message #34931 ] Fri, 23 September 2011 01:36 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
input and output layout should be the same so people can open make some changes then save.

Markup or Sales price. Should be an option on upload/download. Some people would find markup easier. I would prefer sales price.


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35124 is a reply to message #34932 ] Mon, 26 September 2011 15:17 UTC Go to previous messageGo to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
Hey guys,

I have a screenshot of the CSV that we will use. Now, before you get all Shocked and Mad about this field and that piece of information not existing, please hear me out!

This forum is one of the ways I've been gathering data about what shopowners want. There are actually quite a few shopowners and designers who (unfortunately) aren't as active on the forum as you all are, people that I talk to in person, over PM, email, etc. There are designers I know will be just as Sad at me for making the spreadsheet too complicated, and filled with data they don't need. So, this is a compromise that I think will satisfy the 80/20 rule and give you all the bulk of what you need to do manage your markups, definitely to make it easier for you to update prices given the upcoming price change. So hopefully, it's a tool that will in ultimately make everybody a bit more Very Happy , even if it doesn't satisfy to the T everybody's individual, specific needs.

This tool is planning to be released this Wednesday.

Thanks,
Nancy

[Updated on: Mon, 26 September 2011 15:32 UTC]



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #35129 is a reply to message #35124 ] Mon, 26 September 2011 15:37 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
yep. you picked about the worst possible layout you could. SO for my shop I will have 9351 lines(374*25+1). And have to write a ridiculously complicated formula to read the material id and volume. The formula is going to be like a page long Sad Oh well I can write it but it will not be fun. Especially if I ever have to change it.

SO are we actually going to be able to have the same model both public and private of different materials? 543211 is public in Silver Glossy but Private in Silver.

Please tell me I can upload based on sale price. The formula is going to be just rediculous if I also have to compute the base cost to reduce.

Please tell me materials not currently for sale will be listed. Will not be very useful if you do not include every single material. For example if you add a new material, you should set that to not available for safety reasons. But I will want to go through and make available some through CSV. Which means you must have all 30(or however many materials there are) for every single model. Weather or available in that material or not. Which means we need a way like entering -1 into sales/markup to signal it is not available.

[Updated on: Mon, 26 September 2011 16:23 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35131 is a reply to message #35124 ] Mon, 26 September 2011 15:48 UTC Go to previous messageGo to next message
avatar stop4stuff  is currently offline stop4stuff
Messages: 3118
Registered: June 2010
Go to my shop
Shapie Expert
Nancy, you might want to have a quiet word with 'The Coders' wrt Private & For Sale models... tis a rrpita trying to get the 'special hashtag' for such a model - otherwise... what does CSV mean?

Re: Mass Markup Tool Question [message #35132 is a reply to message #35131 ] Mon, 26 September 2011 15:51 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
CSV: Coma Seperated Values

It is a generic input format for spreadsheet programs


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35145 is a reply to message #35132 ] Mon, 26 September 2011 16:44 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
Can we at least get a notes field where we can type in a 4 digit number. Please. It would be very beneficial to automation with this layout. Just store it in your database and only ever read/write it from the CSV sheet.


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35153 is a reply to message #35145 ] Mon, 26 September 2011 17:18 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
mctrivia wrote on Mon, 26 September 2011 16:44

Can we at least get a notes field where we can type in a 4 digit number.


What's the purpose of such a number?


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #35157 is a reply to message #35129 ] Mon, 26 September 2011 17:23 UTC Go to previous messageGo to next message
avatar Magic  is currently offline Magic
Messages: 1187
Registered: August 2008
Go to my shop
Shapie Expert
Shapeways Crew
mctrivia wrote on Mon, 26 September 2011 15:37

SO for my shop I will have 9351 lines(374*25+1). And have to write a ridiculously complicated formula to read the material id and volume. The formula is going to be like a page long Sad Oh well I can write it but it will not be fun. Especially if I ever have to change it.


I suppose this file is done to set up markup based on Shapeways price, not on volume and material.
Something like:
- if Shapeways price is comprised between $0 and $10 add 20% and round to the next multiple of $2 and remove 1 cent.
- If it is more than $10 add 15% and round up to the next multiple of $5 and remove 10 cent.

Such a formula should be easy to write...




So many things to design, so little time...
Re: Mass Markup Tool Question [message #35158 is a reply to message #35124 ] Mon, 26 September 2011 17:25 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
nancyliang wrote on Mon, 26 September 2011 15:17


I have a screenshot of the CSV that we will use.


Nancy, overall, it looks good. I assume "Price" is the retail price that a customer sees?

Can you consider one thing? Please provide us with a fixed URL to a second CSV file with the prices per material_id. This file would be static.. based upon the current prices in effect.


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #35159 is a reply to message #35153 ] Mon, 26 September 2011 17:26 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
notes are to let me write formulas based on it. i would use to make product groups.

1=normal die
2= specialty die
4=set
8=...

someone else may use for something different. just a note on how to price. each shop can use as they like. i said 4 digit number to simplify for shapeways and limit database size.

[Updated on: Mon, 26 September 2011 17:28 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35161 is a reply to message #35157 ] Mon, 26 September 2011 17:30 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
Magic wrote on Mon, 26 September 2011 17:23

mctrivia wrote on Mon, 26 September 2011 15:37

SO for my shop I will have 9351 lines(374*25+1). And have to write a ridiculously complicated formula to read the material id and volume. The formula is going to be like a page long Sad Oh well I can write it but it will not be fun. Especially if I ever have to change it.


I suppose this file is done to set up markup based on Shapeways price, not on volume and material.
Something like:
- if Shapeways price is comprised between $0 and $10 add 20% and round to the next multiple of $2 and remove 1 cent.
- If it is more than $10 add 15% and round up to the next multiple of $5 and remove 10 cent.

Such a formula should be easy to write...




you are write a simple round up pricing would be easy on this. mine will be doable but not easy. will probably write a program to generate..


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35162 is a reply to message #35158 ] Mon, 26 September 2011 17:32 UTC Go to previous messageGo to next message
avatar Magic  is currently offline Magic
Messages: 1187
Registered: August 2008
Go to my shop
Shapie Expert
Shapeways Crew
stonysmith wrote on Mon, 26 September 2011 17:25

I assume "Price" is the retail price that a customer sees?

Oops! I assumed it was the price excluding markup and VAT (Shapeways' price).
Nancy?

[Updated on: Mon, 26 September 2011 17:40 UTC]


So many things to design, so little time...
Re: Mass Markup Tool Question [message #35163 is a reply to message #35159 ] Mon, 26 September 2011 17:33 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
Quote:

1=normal die
2= specialty die
4=set
8=...

Ah, I get it.

For my shop, I would keep such info in a second sheet (table) organized simply by model_id.... easy to bring in via a VLOOKUP function.

[Updated on: Mon, 26 September 2011 17:34 UTC]


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #35165 is a reply to message #35163 ] Mon, 26 September 2011 17:42 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
if i must i can look up how to use that function.

just did. can you get table from external file?

[Updated on: Mon, 26 September 2011 17:44 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35166 is a reply to message #35165 ] Mon, 26 September 2011 17:57 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
mctrivia wrote on Mon, 26 September 2011 17:42

Can you get table from external file?


Yes, you can. It works a little easier if the external file is XLS format..

The calculations you described above as being arduous - really should simple, and not be any trouble. As soon as the main CSV file is ready Wednesday, I'm sure that several people will be offering pre-built spreadsheets with all kinds of fancy tricks.

[Updated on: Mon, 26 September 2011 17:57 UTC]


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #35168 is a reply to message #35163 ] Mon, 26 September 2011 18:01 UTC Go to previous messageGo to next message
avatar nancyliang  is currently offline nancyliang
Messages: 155
Registered: January 2011
Go to my shop
Senior Member
I work here
The price columns are meant to be BASE price (price pre markup, pre VAT). It also saves you the trouble of calculating what your base price is based on old handling fee, new handling fee, density discount and so on--this is so you can focus on what margins you want. Hope that clears things up.

Thanks,



Product Manager
Twitter: @nliang
Re: Mass Markup Tool Question [message #35169 is a reply to message #35166 ] Mon, 26 September 2011 18:05 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
yes vlookup should simplify my calculations greatly. i thought i was going to need 150 if statements 6 per material


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35170 is a reply to message #35168 ] Mon, 26 September 2011 18:08 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
nancyliang wrote on Mon, 26 September 2011 18:01

The price columns are meant to be BASE price (price pre markup, pre VAT). It also saves you the trouble of calculating what your base price is based on old handling fee, new handling fee, density discount and so on--this is so you can focus on what margins you want. Hope that clears things up.

Thanks,

so we will have to subtract this from sales price to enter in markup field? and will you give me all 9351 lines for my shop?


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35172 is a reply to message #35170 ] Mon, 26 September 2011 18:16 UTC Go to previous messageGo to next message
avatar stonysmith  is currently offline stonysmith
Messages: 2035
Registered: August 2008
Go to my shop
Shapie Expert
moderator
mctrivia wrote on Mon, 26 September 2011 18:08

so we will have to subtract this from sales price to enter in markup field? and will you give me all 9351 lines for my shop?


Different people will process it different ways. I myself will simply take the Price (Cost) and multiply it by 20% for the Markup. Others who want a fixed sales price will need to subtract the Cost from the CustomerPrice to determine the markup.

That's the beauty of this.. you can handle it many different ways.

Yes, expect 9351 lines, unless Nancy throws in a new material for October. Then it'd be 9376. <grin>

[Updated on: Mon, 26 September 2011 18:21 UTC]


Patience, Persistance, Politeness - the 3Ps will help us get us to Perfect Printed Products
Re: Mass Markup Tool Question [message #35173 is a reply to message #35168 ] Mon, 26 September 2011 18:20 UTC Go to previous messageGo to next message
avatar stop4stuff  is currently offline stop4stuff
Messages: 3118
Registered: June 2010
Go to my shop
Shapie Expert
I'm getting a bit lost here.

Q1) Is this tool a stand alone bit of software that anyone can use?
Q2) Will the 'tool' have an entry that will allow me to put in a % markup for all my models?

Cheers,
Paul
Re: Mass Markup Tool Question [message #35174 is a reply to message #35173 ] Mon, 26 September 2011 18:22 UTC Go to previous messageGo to next message
avatar mctrivia  is currently offline mctrivia
Messages: 808
Registered: September 2010
Go to my shop
Senior Member
this will export a file that can be read by excel. You can then use all the power of excel to set your price. You can then upload the result to make perminent.

To set a 20% markup to everything. You would type in I2

=$I2*1.2

then cut and past that to all values in I. Then copy all values in I and past value only over top of it.

[Updated on: Mon, 26 September 2011 18:25 UTC]


Follow me on twitter http://twitter.com/mctrivia or my blog at http://4ddice.blogspot.com/
Re: Mass Markup Tool Question [message #35175 is a reply to message #35172 ] Mon, 26 September 2011 18:25 UTC Go to previous messageGo to previous message
avatar tebee  is currently offline tebee
Messages: 436
Registered: December 2010
Go to my shop
Senior Member
This is the great advantage of having this in CSV.

We can import that CSV into a spreadsheet, apply whatever formulas we want on it, then export the results to a new CSV and upload this back and change all our mark-ups rather than having to do each one individually.

That's 9351 numbers it's saved you keying in Smile

Pages (2): [1  2    »] 
   
Previous Topic:It Prints then it Won't
Next Topic:Greatest idea ever! (Cool for Halloween too)

Logo

Hello.

We're sorry to inform you that we no longer support this browser and can't confirm that everything will work as expected. For the best Shapeways experience, please use one of the following browsers:

Click anywhere outside this window to continue.